Forum Discussion

Neel98's avatar
Neel98
Frequent Visitor
3 years ago

Cummulative Sum

Hello All, I want to find out the cumulative sum without a date field and have attached the data for your reference. Could you please share the dax for cummulative sum?  
DAX
Nathaniel_C's avatar
Nathaniel_C
Community Champion
3 years ago

Hi Neel98 
Add an Index column to your table in Power Query

 

Use this if you want a total amount

Running Total = 
VAR  _tableIndex = MAX('Table'[Index])
//Var _Area = MAX('Table'[Area])

var _calc = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex))
//Var _calcArea = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex && 'Table'[Area]=_Area))
return _calc
Use this if you want a running total that is for each area.

Running Total Area = 
VAR  _tableIndex = MAX('Table'[Index])
Var _Area = MAX('Table'[Area])

var _calc = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex))
Var _calcArea = Calculate(SUM('Table'[Quanity]),FILTER(ALL('Table'), 'Table'[Index]<=_tableIndex && 'Table'[Area]=_Area))
return _calcArea



Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel