If row is empty then text

[Anonymous]

Hello,

I want to give out a standardized text if the row is empty/blank:

So that instead of an empty cell in the visual, it says something like "TBD"

Do you know how to achieve that? 

Thank you very much. 🙂


Best Regards
Jannis

[v-shex-msft]

Hi @Anonymous,

You can write an if statement to compare with the current value to replace if the current value equal to blank.

To handle blank values in dax, you can take a look at the following blog:

Handling BLANK in DAX - SQLBI

Regards,

Xiaoxin Sheng

[PurpleGate · Accepted solution]

= IF(isblank(columnname),"TBD",[value])

[value] is whatever you are trying to put in the column normally.