Power BI Running Total or Cumulative Sum with DAX

In this video I show you how to calculate the running total (cumulative sum) in Power BI with DAX.

So if you want to know how to calculate the cumulative sum of running total in DAX, this video is for you.

First I'll show you how to calculate the running total based on a variable date with a slicer with the DAX function ALLSELECTED.

Then you will learn how to calculate the running total in Power BI with the ALL function in DAX, which ignores the date fields.

All in all, you have an example of how to calculate the running total or cumulative sum in DAX in Power BI.

[rschloch]

So happy this video had background music to help subdue that horrible ringing sound.

[aleksanderrode]

Patrick, it is great video how to calculate cummulative values. I did not think that it is so easy.
I'm interesting how you did those white boxes with years - they are interactively change in size when you use a slicer. Can you comment on this - I did not found a video for this .

[AK-ljze]

That's amazing @Patrick. However, please explain what if I wish to condition the Cumulative Curve to look for a value in a column and lookup for corresponding date in other column to end let's say Feb 2019. I mean to say I wish to cumulate the cost with a condition that if column contains value 'x' in col A then consider the max date in col B and do the cumulative sum. Max date encountered in col B with "X" in col A is 21-Feb-2019 so the curve should disappear from Mar-2019 onwards. How do we achieve this?

[benjaminanic]

Hey Mate - great video, thank you for the content. I have a question, I have an initial contract budget value column (one record) in one table and a column with many contract change orders in another table. How can I create a running total that starts with that initial contract budget value column and the running total is based on contract change orders. Let me know if you can help! Thanks in advance

[hudsonvasconcelos]

Boa tarde
Estou tentando efetuar uma soma acumulada. Que funcione da seguinte forma.
Ex : tenho três ano na base, 2020 a 2022, quando selecionar o ano primeiro retorne a soma do ano. Depois quando for filtrar pelo mês quero que traga a soma do mês selecionado mais os meses anteriores.
Ano 2021, 1.528. qnd selecionar o mês de abril, a soma de abril + os meses anteriores correspondente ao ano filtrado.

Alguém já realizou algo nesse sentido.

[MultiAllaeddine]

Moving around the screen like that is a great distraction