•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#moving range
#power query
#Nth cell
#N-1 cell
#absolute value
#difference
#Excel
#add a column
#current cell
#calculates
#calculating
#cell difference
#stuck
#data analysis
#data transformation
#link