Forum Discussion
Solved
Moving Average in Power Query M
How do you create a moving, or rolling, average in Power Query? I already know how to do this in DAX, Excel, and Power BI, but I need to know how in Power Query. Mainly because I need to use the re...
jsflint
This question was answered over here:
https://community.powerbi.com/t5/Power-Query/Exponential-Moving-Average-in-Power-Query-M/m-p/1897358#M56186
M is, no doubt, capable of processing data this way but is not inherently designated for such things.
Ok thanks. Now a follow up question. Is it possible to build an exponential moving average, of the same duration, off the simple moving average?
jsflint
This question was answered over here:
https://community.powerbi.com/t5/Power-Query/Exponential-Moving-Average-in-Power-Query-M/m-p/1897358#M56186Ok, but what if I want to reset the average every month..??
