Forum Discussion

New Member

9 years ago

Solved

_Moving_Average

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 ...

Need Help

Vvelarde

9 years ago

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

Vvelarde

Community Champion

9 years ago

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

Microsoft Employee

9 years ago

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. :)