Forum Discussion

Guruprasad7's avatar
Guruprasad7
Regular Visitor
4 years ago

calculating rolling average or cumulative average

Hi All, Newbie Here..  I'm calculating rolling average using below DAX for a seleceted date range, but not finding the desired output. Even Tried :  Calculate(Avgerage(sheet1[RATIO]), Filte...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Guruprasad7 

 

You have 2 tables, right? [Ration] is in Sheet1, and date slicer is using Table? What is relationship between these two tables? Table is like a Date table? if yes, 1:N relationship with Sheet1, only use to display May - Oct (sample period), then try it, otherwise provide more info and sample data

test = 
VAR CurMax = MAX(sheet1[Date])
RETURN
AVERAGEX(FILTER(ALL(sheet1),sheet1[Date]<=CurMax),sheet1[Ratio])