Print

Running totals in power query – Part 1

In today’s video, I am going to show you how you can do running totals or cumulative totals in Power Query, but do this only if you have no way to do it using DAX.

Also, I will show you how List.Range work, really cool function 🙂

Table of contents:

00:00 Use case description
00:57 Show how List.Range works
02:00 Create an Index
02:40 Create the range
03:25 Transform a column to a list
05:10 Sum the values

Watch the tutorial:

Running totals in power query??? Yes, you can :)

Links to the mentioned resources

If you need the running totals by subgroup, watch Part 2:

Running totals by subcategory in Power Query!!
Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents