Forum Discussion

KarakiLaMaravil's avatar
KarakiLaMaravil
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 immediately preceding dates. Thank you very much in advance

 

 

 

 

Need Help
  • Vvelarde's avatar
    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] ) )
    )

2 Replies

  • Vvelarde's avatar
    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's avatar
      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. :)