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:
Links to the mentioned resources
If you need the running totals by subgroup, watch Part 2:
Was this helpful?
Reader Interactions