topic Re: Cummulative Sum in DAX Commands and Tips

Cummulative Sum

Neel98 — Sat, 24 Jun 2023 15:57:53 GMT

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?

Re: Cummulative Sum

Nathaniel_C — Sat, 24 Jun 2023 20:09:25 GMT

Hi Neel98 ,
Would you please give us more details? Do you wish the cumulative QTY based on all the rows, or on the material or area?

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

Re: Cummulative Sum

Nathaniel_C — Sat, 24 Jun 2023 20:48:58 GMT

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