Forum Discussion
Need help with running total
I am atemting to get a running total from the start of wnd of 2019 to the current date. Included is a picture of my dax code that is not currently working. Thanks!
I was able to fix it by making a my own date table and using this code:
Total Revenue running total in Quarter =CALCULATE(SUM('Matt-DataForBI'[Total Revenue]),FILTER(ALLSELECTED('Date'[Quarter]),ISONORAFTER('Date'[Quarter], MAX('Date'[Quarter]), DESC)))
AlexisOlson
Super User
Super UserHmm. What if you replace ALLSELECTED ( 'Matt-DataForBI'[Date Closed] ) with ALLSELECTED ( 'Matt-DataForBI' )?
I was able to fix it by making a my own date table and using this code:
Total Revenue running total in Quarter =
CALCULATE(
SUM('Matt-DataForBI'[Total Revenue]),
FILTER(
ALLSELECTED('Date'[Quarter]),
ISONORAFTER('Date'[Quarter], MAX('Date'[Quarter]), DESC)
)
)
- AlexisOlson
Great! Having a date dimension table is almost always a good idea.