Forum Discussion
Solved
Cumulative Total query
Hi, I have data that I've been asked to include a cumulative total beside. All the data is from the 1st day of various months: However when I add the cumulative total, it puts...
Try this, and let me know if there are any problems:
Depletion Cumulative Total =
IF ( NOT ISBLANK(SUM(Depletion[9LE])),
CALCULATE(
SUM(Depletion[9LE]),
FILTER(
ALLSELECTED(Dim_Date[Date]),
Dim_Date[Date] <= MAX(Dim_Date[Date])
)))
Hi,
Thank you for your response.
I tried this but it doesn't seem to work:
Try this, and let me know if there are any problems:
Depletion Cumulative Total =
IF ( NOT ISBLANK(SUM(Depletion[9LE])),
CALCULATE(
SUM(Depletion[9LE]),
FILTER(
ALLSELECTED(Dim_Date[Date]),
Dim_Date[Date] <= MAX(Dim_Date[Date])
)))
That worked, thank you so much!
My pleasure!