The 2nd Edition of #25daysofdaxfridays challenge is here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

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