Forum Discussion
Solved
Decreasing Running Total Measure with Date Hierarchy
Hello, I have a running total measure of costs with an end date and the quick measure function with some small changes gives a correct output. I'd like to represent this in Quarters,...
Nevermind, used the wrong columns.
This is what I wanted.
amitchandak
Super User
Super Usermoldfield , Try a measure like the example
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] >=max('Date'[date])))
Thank you for the response. The difference between this example (which I think is the default running total measure) and mine is the date column in the all selected and the max instead of min (since I need a decreasing total). Adding the column back in to the filter doesn't look right.