Forum Discussion
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 an index column does not work as it does not stop and start afresh when a new discpline is encountered or a new site and discipline start.
Data
Desired output
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])
)
)
1 Reply
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])
)
)