Forum Discussion

Kanyi's avatar
Kanyi
Frequent Visitor
2 years ago
Solved

Multiple category cumulative sum

Hi please assist. I have been struggling with the below, any help will be apreciated. I want to calculate a cumulative sum of the metres based on site and discipline. The running total and creating a...
Need Help
Tips and Tricks
Tutorial Requests
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Kanyi , Create a calculated column using below DAX

     

    CumulativeSum =
    CALCULATE(
    SUM(Table[Metres]),
    FILTER(
    ALLEXCEPT(Table, Table[Site], Table[Discipline]),
    Table[Date] <= EARLIER(Table[Date])
    )
    )

bhanu_gautam's avatar
bhanu_gautam
Super User
2 years ago

Kanyi , Create a calculated column using below DAX

 

CumulativeSum =
CALCULATE(
SUM(Table[Metres]),
FILTER(
ALLEXCEPT(Table, Table[Site], Table[Discipline]),
Table[Date] <= EARLIER(Table[Date])
)
)