Monday, January 9, 2023

Running Total in Power Query

Creating a running total in Excel is easy, really easy if you're an intermediate Excel user. Why then would we consider doing this in Power Query? Maybe it's a small part of a series of steps you're doing to clean up data. In that case you don't want to have a running total calculation outside of your Power Query steps. Unfortunately there is no Ribbon command in the Power Query editor to perform running totals. Don't worry, it's actually quite easy to do a running total in Power Query. It's just some M code and it's not even a lot.

No comments:

Post a Comment