Forum Discussion
akhassim
2 years agoNew Member
undefined
I need to calculate a cumulative total. How do I do this
some_bih
2 years agoCommunity Champion
Hi akhassim please create measure as below Cumulative test.
If you do not have already Calendar / Date table, create one using link as instruction below
Cumulative test =
VAR __max_date = MAX ( 'Date'[Date] ) -- your Date table
RETURN
CALCULATE (
SUM(Cost Actual)],
'Date'[Date] <= __max_date,
ALL ( Date )
)
Create Calendar Table Microsoft Learn
https://learn.microsoft.com/en-us/power-bi/guidance/model-date-tables
Did I answer your question? Kudos appreciated / accept solution!