Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
hi, @sparkplug9375
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
The actual YTD is now stopping at the correct spot but not actually curving
hi, @sparkplug9375
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |