Limiting Running Total to Today

[Jondon29]

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 - DateTable'),'1 - DateTable'[Date]<=MAX('1 - DateTable'[Date])),[Completed])

[AlB · Accepted solution]

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.

[Jondon29]

That worked perfect, thank you very much.