Creating a Running Total in Power Query

Want to create a Running Total in Power Query? This video shows you the steps required to make a Running Total. Learn how to combine several functions to get your desired result.

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerQuery #RunningTotal #BIGorilla

[wayneedmondson]

Awesome! If you want to skip creating a list buffer step, it can be embedded directly into the List.FirstN() function list argument. Using your example, it would be: List.FirstN(List.Buffer(Source[Amount]), [Index]). Not as visual as creating a step and referencing the step, but also not that hard to understand when looking at the M code. Love your channel and videos! Learn a lot each time. Thanks for sharing :)) Thumbs up!!

[dganalysis]

Worked a treat - particularly with the BufferedList

[anthonymolyneaux]

Thank you! I had the first part, but my queries were taking 20 minutes to refresh. The List.Buffer function reduced my query speed to 1-2 minutes!

[leonardsymeonides]

Any videos on creating a running total in DAX please? Love your content!

[rchong]

Wonderful, thanks. It will take a long time for me to understand the logic as it seems so advance. Any direction to learn to comprehend this List command ? :-)

[williamarthur]

Regarding the buffer, which I always find confusing, yes worked fine. would you use table.buffer if more than one column involved. Also how about a video on running totals by criteria or group?

[josephthibault]

slower but easier than dax for sure if you are not using dates

[guilianamustiga]

Thanks so much for the video, how do I do a running 12 month total in power query?

[mandarnandre]

What to do if I have a running total and want to get normal total for each enetity