12 Month Rolling Average (Fiscal Calendar) Calculation
Hi, I'm trying to recreate the following formula from Excel in DAX: The 12 month rolling avergae formula is: =SUM(E81:E133)/SUM(D81:D133)*100000 =SUM(E82:E134)/SUM(D82:D134)*100000 =SUM(E83:E135)/SUM(D83:D135)*100000 Column E is Total X Column D is Total Y So it's basically summing the last 53 rows of the 'Total X' column divided by last 53 rows of 'Total Y' column * 100000. I'm using the company calendar which is fiscal periods so cannot use any of the inbuilt date/time intelligence functions or the quick measures. My calendar looks like this: Please could someone explain how I can create the same formula in dax...It's driving me mad!
