Forum Discussion
Solved
Cumulative total as continuous line on graph
I am trying to show the cumulative total of revenue as a continuous line on a graph, This is the formula I am using for my cumulative total: Cumulative Revenue = CALCULATE(SUM('Invoice by Task an...
You need to use the actual calendar table in your measure as well.
Cumulative Revenue = CALCULATE(SUM('Invoice by Task and Date'[Actual Revenue]), Filter(ALL(Calendar), Calendar[Date] <= MAX(Calendar[Date])))
If you have some way to trim your calendar days to the end of your sales data, that is best.
Otherwise you will need to filter your cumulative total measure to dates <= "last sale date" which you could write in a separate measure.
Otherwise you will need to filter your cumulative total measure to dates <= "last sale date" which you could write in a separate measure.
thank you so much!