Forum Discussion
Moving average weekly
Hello, I have calculated measure (values) and I want to see moving average based on weeks. This is what it should look like: Week values moving average - should be 1 187 750 187 750 ...
evadung , You have to try a measure like
Cumm Sales = CALCULATE(AverageX(Values('Date'[Week Year]), CALCULATE(SUM(Sales[Sales Amount]))),filter(all('Date'),'Date'[date] <=max('Date'[date])))