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 |
| 2 | 493 333 | 340 541,5 |
| 3 | 775 840 | 485 641 |
I tried this formula but it shows wrong values:
Moving average =
averagex(
FILTER(ALLSELECTED(Kalender),
Kalender[Datum] <= MAX(Kalender[Datum)),
[Gesamtleistung])
Do you have any ideas?
1 Reply
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])))
