PowerBI Project On Track

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.