Forum Discussion
Solved
Issue with rolling 6 month average
Hi, I'm having some trouble with a rolling 6 month average. I have the following order data: The data is taken from a count of orders - each order has its own row, and the order numb...
Hi ChrisB1977,
Based on my test, you could refer to below steps:
Create a calender table:
Table = CALENDARAUTO()
Create a measure:
Orders R 6M Ave = DIVIDE(CALCULATE(SUM(Table1[Order number]),DATESINPERIOD('Table'[Date],MAX('Table1'[Month]),-6,MONTH)),6)Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi ChrisB1977,
Based on my test, you could refer to below steps:
Create a calender table:
Table = CALENDARAUTO()
Create a measure:
Orders R 6M Ave = DIVIDE(CALCULATE(SUM(Table1[Order number]),DATESINPERIOD('Table'[Date],MAX('Table1'[Month]),-6,MONTH)),6)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi v-danhe-msft
That worked, thank you so much! It's also solved several other issues for me so I'm very grateful :)
Best regards
Chris