In the Adventurework FactInterSales table, there's an "orderDateKey" key.
Imagine that I want to add a new calculated measure, in order to be able to get the average delay (in days) between sales, in general or by customer...
How would you do that ? A new calculated member ? a script command ? Or do I have to do this with SSIS when importing the data ? I hope no...
I've been searching on the net, the DATEDIFF function seams to be the solution, but I couldn't make it work successfully
Thanks a lot for your help
View Complete Post