PowerBI Project On Track

[TomFarmer24]

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!!

[rajendraongole1 · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[rajendraongole1 · Accepted solution]

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.