Forum Discussion
Rolling average last 3 rows
Hi, I'm new here and I need some help. I would like to calculate a "W-kee" rolling average over the last 3 rows in the table example as below: So the result should be ((1+4+1)/3=2), but...
Hi,
According to your description, I can roughly understand your requirement, you can try this measure to get the expected result:
Rolling average = var _lastrow=CALCULATE(MIN('Table'[SPR]),FILTER(ALL('Table'),[W-kee]=BLANK()&&[W-def]=BLANK()&&[W-mid]=BLANK()&&[W-att]=BLANK())) return CALCULATE(AVERAGE('Table'[W-kee]),FILTER(ALL('Table'),[SPR]<=_lastrow-1&&[SPR]>=_lastrow-3))And you can get what you want, like this:
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
var Rolling Average= CALCULATE(Table[W-knee], FILTER(ALLSELECTED(Table[SPR]), ISONORAFTER( Table[SPR], MAX(Table[SPR]), asc)))
Return (Rolling Average/ 3)
Mark this as a solution, if I answered your question. Kudos are always appreciated.
Thanks