Forum Discussion
Calculated Column Average Last Three Values
Hello, I am currently trying to find a way to average the last three values in a column. Currently, my Data Set looks like this: Rank Division Fiscal Year Participant Count 1 A 2020 14 ...
Hi,
to solve this issue you have to create a recursive function in PowerQuery, it cannot be solved with DAX.
A possible starting point for reading about recursion could be this blog post:
https://www.thepoweruser.com/2019/07/01/recursive-functions-in-power-bi-power-query/
You could also consider asking your question in the power query forum:
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services
Cheers,
Sturla