•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculating moving range in power query
Our take
Calculating moving ranges in Power Query can initially seem challenging, especially if you're accustomed to the simplicity of Excel. However, it’s entirely possible to add a column that computes moving ranges efficiently. A moving range represents the absolute value of the difference between the current cell and the previous one, calculated as |Ni - Ni-1|. By leveraging Power Query's capabilities, you can streamline your data analysis and enhance your insights. Let's explore how to implement this calculation and improve your workflow with ease.
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]
Read on the original site
Open the publisher's page for the full experience