Moving average weekly

[evadung]

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?

[amitchandak]

@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])))