cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lovility Frequent Visitor
Frequent Visitor

Replace BLANK to another text

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Replace BLANK to another text

@lovility 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.

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






5 REPLIES 5
JayHerrera Frequent Visitor
Frequent Visitor

Re: Replace BLANK to another text

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

Super User
Super User

Re: Replace BLANK to another text

@lovility 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.

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






lovility Frequent Visitor
Frequent Visitor

Re: Replace BLANK to another text

Start End date type is datetime

Super User
Super User

Re: Replace BLANK to another text

@lovility did you tried the measure I posted?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






lovility Frequent Visitor
Frequent Visitor

Re: Replace BLANK to another text

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 helpSmiley Happy