Forum Discussion

desiiirz's avatar
desiiirz
Regular Visitor
3 years ago

Cumulative Sales

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 ec...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi desiiirz 

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.