_Moving_Average

[KarakiLaMaravil]

Hi,

I need to create a daily moving average. How can I create in the formula in the second field can put the date behind in a period? That is, the moving average is calculated with the two immediately preceding dates. Thank you very much in advance

[Vvelarde · Accepted solution]

@KarakiLaMaravil

Hi. tri with this

Ventas average =
VAR LSTDATE =
    LASTDATE ( 'Table2'[Fecha] )
RETURN
    AVERAGEX (
        DATESBETWEEN ( 'Table2'[Fecha], DATEADD ( LSTDATE; -2,DAY ), LSTDATE),
        CALCULATE ( SUM ( 'Table2'[Ventas] ) )
    )

[Eric_Zhang]

@KarakiLaMaravil

I see you've given kudo to @Vvelarde. Is your question answered? If no further question, you can accept the answer as solution to close this thread. For any question, feel free to post. 🙂