Forum Discussion
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]...
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.
JayHerrera
Advocate I
Advocate IAnonymous What data type are your "start" and "end" data fields?
Start End date type is datetime
- parry2k
Super User
Anonymous did you tried the measure I posted?