Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

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

Let us know your thoughts...

Table of Contents