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)

 

 

  • ViralPatel212's avatar
    ViralPatel212
    Resolver I
    2 years ago

    @amitchandak That worked partly. I have a identifier in my date table called Weekend. If its a Weekend say YES else No. 

    How do i tweak the measure to exlcude weekend?

    thanks

    Viral