How to fix blank value in dates column

[Anonymous]

Here is my DAX for column [Estimated End Date] 

Estimated End Date = Trainings[Start Date] + RELATED(Courses[DurationDays] )

Both No Course and Unsubmitted does not have any values in column [DurationDays]
Is there a way to fix the values within [Estimated End Date] and change from 30/12/1899 into - 

[Pragati11]

Hi @Anonymous ,

You can modify your dax as follows:

Estimated End Date = IF(NOT(ISBLANK(Courses[DurationDays])), Trainings[Start Date] + RELATED(Courses[DurationDays] ), "-")

Thanks,

Pragati

[Anonymous]

[harshnathani]

HI @Anonymous ,

I think you are creating a measure.

You need to create a Calculated Column

Pls check.

Regards,

HN

[Anonymous]

It still does not work and I don't know why.

[harshnathani]

HI @Anonymous ,

Then apply the formula which @Pragati11  has written.

Thanks 

HN

[Anonymous]

Hi @harshnathani  @Pragati11 
It's still give me an error though.