•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculating moving range in power query
As stated in the title, I'm wondering if there is a way to add a column that calculates moving ranges in power query. Pretty easy in excel but I'm stuck in PQ.
Edit: moving range is the absolute value of the difference between the current Nth cell and the Nth-1 cell: /Ni-Ni-1/.
[link] [comments]
Want to read more?
Check out the full article on the original site