Replace BLANK to another text

[Anonymous]

I have start and end data columns

Some End data is blank. so Chart shows that data (Blank)

I would like to change that (Blank) to another text.

I tried

New Measure = if(ISBLANK([Original Measure]),"Presence",[Original Measure])

But I got error that "Expressions that yield variant data-type cannot be used to define calculated columns."

Is there any way to change (Blank) text?

Thank you advance!

[JayHerrera]

@Anonymous  What data type are your "start" and "end" data fields? 

[Anonymous]

Start End date type is datetime

[parry2k]

@Anonymous did you tried the measure I posted?

[parry2k · Accepted solution]

@Anonymous seems like your [original measure]  is not of text type, you can do something like this

 New Measure = if(ISBLANK([Original Measure]),"Presence",
FORMAT([Original Measure], "######0.00" ) )

basically you are converting your original measure to text, you can change the format string based on your need.

[Anonymous]

Hi, Your Answer is great! I try it and work!

My data is datetime format, so use your code like this:

EndTimeFix = IF(ISBLANK([EndTime]),"Presence", FORMAT([EndTime],"General Date"))

Thank you for your help:)