Forum Discussion
PowerBI Project On Track
Hi all,
I have asked this question previously but I have a part two!
The original question was…
I am looking at creating a simple visualisation that can tell me the number of projects that are on track to meet approved cost and schedule.
I am looking at using the Forecast Completion Date that we have through progress reports and then the Approved Completion Date all synced to my Excel spreadsheet (forecast and approved completion are columns within my spreadsheet).
I don’t want anything too fancy, just a chart or something showing those on-track to completion and those that are not.
The solution I had from bhanu_gautam (thanks a bunch!!!) was
OnTrack = IF([ForecastCompletionDate] <= [ApprovedCompletionDate], "On Track", "Not On Track")
I am now looking for an additional line to help display any projects that don’t have a forecast date to display ‘data missing’.
Thanks in advance!!
Hi TomFarmer24 - You can modify the OnTrack measure to handle missing forecast dates using IF and ISBLANK.
can you check the below logic:
OnTrackStatus =
IF(
ISBLANK([ForecastCompletionDate]),
"Data Missing",
IF([ForecastCompletionDate] <= [ApprovedCompletionDate], "On Track", "Not On Track")
)this helps to see the data for on track on and not on track projects. Hope this helps.
Hi ,
Based on the information, the DAX formula provided above should show data missing. IF statement first checks if the [ForecastCompletionDate] is blank. If it is, then the measure returns Data missing. Otherwise, it evaluates the comparison between [ForecastCompletionDate] and [ApprovedCompletionDate] to determine whether the project is On Track or Not On Track.
If it does not work, please provide some sample data.
IF function (DAX) - DAX | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi TomFarmer24 - You can modify the OnTrack measure to handle missing forecast dates using IF and ISBLANK.
can you check the below logic:
OnTrackStatus =
IF(
ISBLANK([ForecastCompletionDate]),
"Data Missing",
IF([ForecastCompletionDate] <= [ApprovedCompletionDate], "On Track", "Not On Track")
)this helps to see the data for on track on and not on track projects. Hope this helps.
Hi ,
Based on the information, the DAX formula provided above should show data missing. IF statement first checks if the [ForecastCompletionDate] is blank. If it is, then the measure returns Data missing. Otherwise, it evaluates the comparison between [ForecastCompletionDate] and [ApprovedCompletionDate] to determine whether the project is On Track or Not On Track.
If it does not work, please provide some sample data.
IF function (DAX) - DAX | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.