Filter and stopping line chart at today

[Anonymous]

Hello,

I'm using a running total to graph actual vs forecast. Forecast extends to mid 2020 and the actual should stop at today. My running total column has a second filter depending on if the cell is blank or not.

I've been using this link to stop the actual line but it is not working and giving me a value of zero rather than the measures true value

https://community.powerbi.com/t5/Desktop/Forecasts-for-year-and-actuals-for-ytd-only/td-p/825702

Thanks for your help

[Anonymous]

The actual YTD is now stopping at the correct spot but not actually curving

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You may try to remove ALLSELECTED(Calendar[Date]) in the formula

Actuals Running Total YTD = IF(LASTDATE(Calendar[Date])>=TODAY(), BLANK(), CALCULATE([Existing Measure], ALLSELECTED(Calendar[Date])))

Actuals Running Total YTD =
IF ( LASTDATE ( Calendar[Date] ) >= TODAY (), BLANK (), [Existing Measure] )

 If not your case, please share a simple sample pbix file and your expected output.

Best Regards,

Lin

[Richey1977]

This worked for me.  Thank you.