Forum Discussion

anandmitta's avatar
anandmitta
Icon for Helper I rankHelper I
4 years ago
Solved

Replace blank values with "Null" keyword using measure

Hi,   I have a table visual with contains many date/time rows and columns.     There are many blank values in the table. Is it possible to replace all the blank values in the visual with t...
Need Help
Show and Tell
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Note that if the measure here doesn't return text values, then you may get an error about IF returning different data types. You can fix this by wrapping the measure with FORMAT. and specifying the format you'd like (e.g. "General Date" or "yyyy-mm-dd" or "c" etc).

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi anandmitta ,

It seems you are using Live Connection mode. It means you  can only make changes to it on the Desktop. So it seems that you can only use measures or use calculate table.

Please have a try.

NewTable = 
VAR midT =
ADDCOLUMNS (
'Table',
"Date_", IF(ISBLANK('Table'[date]),"NULL",FORMAT('Table'[date],"YYYY-mm-dd")),
"Start_",IF(ISBLANK('Table'[start]),"NULL",FORMAT('Table'[start],"YYYY-mm-dd")))
RETURN
SELECTCOLUMNS ( midT, "Date", [Date_], "Start", [Start_] )

 

Best Regards

Community Support Team _ Polly

 

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