Forum Discussion

ViralPatel212's avatar
ViralPatel212
Resolver I
2 years ago
Solved

Rolling Average

Hello Team,   I was wondering if i could like a average per row across 5 days dax.  Some background: Trades is a measure with counts the number of occurenaces happens in a table (i.e. counting dup...
Need Help
Show and Tell
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    2 years ago

    ViralPatel212 , You can use these measures

     

    Using date table

    Rolling 5 = CALCULATE(Averagex(Values('Date'[Date]) , [Your measure]) ,DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-5,Day))

     

    Using window

     

    Rolling 12 = CALCULATE(Averagex(Values('Date'[Date]) , [Your measure]) , WINDOW(-4,REL, 0, REL, ADDCOLUMNS(ALLSELECTED('Date'Date]),ORDERBY([DAte],asc)))

     

    Use new visual calculation

    MOVINGAVERAGE([Net], 5)

     

     

amitchandak's avatar
amitchandak
Super User
2 years ago

ViralPatel212 , You can use these measures

 

Using date table

Rolling 5 = CALCULATE(Averagex(Values('Date'[Date]) , [Your measure]) ,DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-5,Day))

 

Using window

 

Rolling 12 = CALCULATE(Averagex(Values('Date'[Date]) , [Your measure]) , WINDOW(-4,REL, 0, REL, ADDCOLUMNS(ALLSELECTED('Date'Date]),ORDERBY([DAte],asc)))

 

Use new visual calculation

MOVINGAVERAGE([Net], 5)