The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have Power BI measure which calculates the cumulative total from a list of values by date sequence.
Cumulative Total =
CALCULATE(
SUM('Data'[values]) ,
'Calendar'[Date] <= MAX( 'Calendar'[Date])
)
This works well but as it is a measure and not a column I'm not able to access any statistics related to the cumulative total, for example if I want to know the maximum value the cumulative total reached across the time period I am not able to use the MAX function as it needs to be applied to data in a column.
Does anyone have any advice on how I can create a cumulative total in a column format?
Thanks,
Neil
Solved! Go to Solution.
Hi @Burtoninlondon - Create a calculated column as below:
Cumulative Total Column =
VAR CurrentDate = 'Data'[Date]
RETURN
CALCULATE(
SUM('Data'[Values]),
FILTER(
ALL('Data'),
'Data'[Date] <= CurrentDate
)
)
it works as cummulative totals as expectd.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @Burtoninlondon - Create a calculated column as below:
Cumulative Total Column =
VAR CurrentDate = 'Data'[Date]
RETURN
CALCULATE(
SUM('Data'[Values]),
FILTER(
ALL('Data'),
'Data'[Date] <= CurrentDate
)
)
it works as cummulative totals as expectd.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |