Forum Discussion
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 duplicates)
Here is my data image:
I can replicate it in excel very simple: with a simple formula =AVERAGE(C2:C6) in cell d2 and in d3 is goes down by 1 i.e d3 cell = average(C4:C7) etc
thanks
viral
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)
3 Replies
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 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
