topic Re: If row is empty then text in DAX Commands and Tips

If row is empty then text

Anonymous — Fri, 19 Aug 2022 08:27:57 GMT

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

PurpleGate — Fri, 19 Aug 2022 08:40:39 GMT

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

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

Anonymous — Tue, 23 Aug 2022 05:44:45 GMT

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:

Regards,

Xiaoxin Sheng