Showing Progress of Task Completion or in-progress but Start Date is missing

[kamini]

Hi folks,

I'm working on this project to show the progress of the work using the Conditional Formatting along with some logicial code. The problem is in some instances, the Start Date is missing but I do have the Create Date when the Task was first created. Could you please help me with the code to use the Create Date Instead of Start Date when the Start Date is NULL?

Below is a snapshot of the report and I'll go ahead and upload the sample .file. 

Thank you so much for your time.

[Anonymous · Accepted solution]

Hi @kamini ,

Do you want to create a calculated column? I think you can try code as below.

New Start Date =
IF (
    'TableName'[Start Date] = BLANK (),
    'TableName'[Creation Date],
    'TableName'[Start Date]
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kamini]

Progress = 
VAR DaysSinceStart = DATEDIFF([Start date], TODAY(), DAY)
VAR TotalDuration = DATEDIFF([Start date], 'ITD Projects'[Due Date], DAY)
VAR ProgressValue = DIVIDE(DaysSinceStart, TotalDuration, 0)
RETURN IF(TODAY() > 'ITD Projects'[Due Date], 1, ProgressValue)