DAX for Power BI - Running Total (Cumulative Sum)

In this tutorial we learn how to create a Running Total measure to calculate the cumulative sum of our data using DAX. This is an extremely useful measure that will add a ton of flexibility to your Power BI report.

To enroll in my introductory or advanced Power BI courses:

[jeffbeckinc]

Look at many sites and this is by far the most straight forward explaination. Thank you very much for posting this!

[StaceyJenkinsdc]

I've been trying different cumulative formulas for a few days and this is the first explanation that got me to a solution. Thanks!

[simonroyjonesuk]

This video is so helpful. I've been trying for ages to get this to work, with no success. This works perfectly. Thanks very much. Simon

[merachannel]

this explanation was so much better than a few other complicated ones!! Thanks a bunch!

[mikehills]

THANK YOU! This is the most straightforward way this has been demonstrated

[andresesquivelmemo]

Thanks for the Video.

If anyone is having this problem: When you change the dates the running total starts from 0, but you want to get the total amount in that period, not the 'new amount' on the period.

To fix this change ALLSELECTED to ALL, that should do it.

[airgid_beithir]

Solved my problem, thank you for putting the effort in to create this.

[gurdylen]

Easiest guide to follow out there! Thanks bro

[kolasrikanth]

Explanation with example made my doubt full clean. Thank you so much.
Hoping for more videos with examples

[aaronrodriguez]

This was great. Short video with simple explanation. Big help!

[adrianpene]

Thanks for the tutorial, I was able to sleep so good listening to this useful info about powerbi. Subscribed

[nancmadi]

Thank you so much for simple quick and thorough instructions.. I built mine right along with you. And accomplished another piece of my HUGE conversion project from Excel to PBI... I have subscribed and hopefully, you will be able to help me more along the way its super complex and I enjoy the challenge. Thank you!

[SOURCEOFFICIELLE]

best cumulative total tutorial out there 🙏🏼🙏🏼

[Monika-hxke]

thank you for teaching me Power BI effectively

[joseblazquez]

Short and to the point, great explanation. Thank you!

[MEPsideofBIM]

Appreciate this very much!
Worked like a charm. Cheers!

[snehadeolikar]

how do you filter out for last 2 months, mine doesnt add the previous data if i filter only 2 months

[otoolepw]

what if you want the running total to restart when a new year starts, i.e. the running total is year to date only

[mhuddlestone]

Thanks for the Video, would this work on a Dax Generated Date Table? This table only has dates, the value I want to do a running sum on is on a different table. The two do have a relationship. Every time I try the value doesn't seem to cumulate over the dates instead stay the same value.

[cemuney]

Hi thanks for videos. i have a simple question. I have also DimDate table. When i use DimDate.Day it shows all the dates in the DimDate table. But i only want to see the Dates which has Orders. Thanks