Forum Discussion
Le-menace
Helper I
Helper ICumulative calculated column (grouped by)
I have a simple table with daily records which I want to accumulate in a new column (a measure is not an option due to other stuff I'd like to do afterwards). I've managed to find an easy way to ...
Please try this column expression instead, replacing Table with your actual table name throughout.
Cumulative Total =
VAR __thisdate = Table[Date]
RETURN
CALCULATE (
SUM ( Table[Value] ),
ALLEXCEPT (
Table,
Table[Name]
),
Table[Date] <= __thisdate
)Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeePlease try this column expression instead, replacing Table with your actual table name throughout.
Cumulative Total =
VAR __thisdate = Table[Date]
RETURN
CALCULATE (
SUM ( Table[Value] ),
ALLEXCEPT (
Table,
Table[Name]
),
Table[Date] <= __thisdate
)
Regards,
Pat
Le-menaceHelper I
Helper Imahoneypat Thanks a lot for quick reply! This seems to work very well. 🙂