Rolling Average

[ViralPatel212]

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

[amitchandak · Accepted solution]

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

@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

[ViralPatel212]

h