Forum Discussion
Solved
Limiting Running Total to Today
Hello, I am trying to limit my running total to today. My current formula is below; I've tried adding a filter to limit to todays date. RunningTotal Completed = SUMX(FILTER(ALLSELECTED('1 -...
Hi Jondon29
You mean you want to show the line only until today?
Assuming your measure works correctly, you can do something like:
NewMeasure = IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )
This returns a blank on dates after today, so that nothing will be displayed. You could also embed this behavior in your current measure.
Hi Jondon29
You mean you want to show the line only until today?
Assuming your measure works correctly, you can do something like:
NewMeasure = IF ( MAX ( '1 - DateTable'[Date] ) <= TODAY (), [YourWorkingMeasure] )
This returns a blank on dates after today, so that nothing will be displayed. You could also embed this behavior in your current measure.
That worked perfect, thank you very much.