Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Running Total Expression

I am trying to calculate the Running total of Backlog count of tickets . I am gettting the Total But there is a requirement : If i am selecting any month then First i need to cumilate the Data up to ...
"Need Help"
DAX help needed
Alf94's avatar
Alf94
Solution Supplier
3 years ago

Hi Anonymous

 

Could you please try the following?

 

Running total = 
    SUMX(
        WINDOW(
            1, ABS,
            0, REL,
            ALL( Table[Year-Month] ),
            ORDERBY( Table[Year-Month], ASC )
        ),
        CALCULATE( SUM( Table[Count] ) )
    )

 

If this measure works, please mark my answer as a solution to help people with the same question as you in the future.

 

Best,