Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

If row is empty then text

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's avatar
    PurpleGate
    4 years ago
    = IF(isblank(columnname),"TBD",[value])

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

     

2 Replies

  • PurpleGate's avatar
    PurpleGate
    Resolver III
    4 years ago
    = IF(isblank(columnname),"TBD",[value])

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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