Cumulative Sum without date column

[Anonymous]

I have a table like this below. Age, Type and Qty are column from file and Cumm Sum is the required column using DAX.

I want Cumm Sum column which will have cumulative sum. Please help me to write DAX to get Cumm Sum column from above example. Thanks in advance,

Rajesh S Hegde

[FrankAT · Accepted solution]

Hi @Anonymous 

take a look at the following solution:

Running Total = 
CALCULATE(
    SUM('Table'[Qty]),
    FILTER(
        ALLEXCEPT('Table','Table'[Type]),
        MAX('Table'[Age (in M)]) >= 'Table'[Age (in M)]
    )
)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Hi @FrankAT ,

This is working as expected. Thanks a lot for quick response.

Regards,

Rajesh S Hegde

[PaulDBrown]

@Anonymous 

What criterium establishes the cumulative values? Is it the Qty? Is it the "Age" column? If so, from max to min or viceversa?

In other words, what establishes the order for the cumulative values?

PS: it would be very helpful if you included the data in a table of actual values (not an image) so we can simply copy and paste to work on...