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

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    3 years ago

    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

  • 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