topic Re: Cumulative Sales in DAX Commands and Tips

Cumulative Sales

desiiirz — Fri, 27 Jan 2023 10:03:44 GMT

Hello,

I want a new column that calculate the cumulative sales A.K.A (nombre de rdv créés)

I come up with the formula below but it calculate me the cumulative sales for each S01, S02, S03 ect...

My ideal result looks like this :

Column A

Line 1 : 20

Line 2 : 50

Line 3 : 10

Column running total :

Line 1 : 20

Line 2 : 70

Line 3 : 80

and so on

FreemanZ — Fri, 27 Jan 2023 12:36:03 GMT

do you have other columns with unique value on each row?

desiiirz — Fri, 27 Jan 2023 12:44:14 GMT

there is no unique value beside "nombre de rdv créées" where there is a lot of 0 value.

Right now, it calcule the cumulative sales for each S01 then S02 ect...

FreemanZ — Fri, 27 Jan 2023 14:09:05 GMT

could you paste your data as text?

desiiirz — Fri, 27 Jan 2023 14:57:00 GMT

FreemanZ Yes, column/mois is already in text

FreemanZ — Sat, 28 Jan 2023 14:17:24 GMT

i mean to paste your sample data as text, so we could copy to Excel/PBI to get the solution for you, instead a screenshot.

Anonymous — Tue, 31 Jan 2023 01:43:33 GMT

You can add an index column in power query

Then create a new column in table.

Running toal = CALCULATE(SUM(RegN[Nombre de ]),FILTER(RegN,[Index]<=EARLIER(RegN[Index])))

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.