Dax to indicate "No" for blanks.

[AMBP73]

Hello everyone.

I have a column that has the values "yes", "Not Reviewed", and blanks. I would like tge blanks to return "no". Could anyone please assist with the correct measure. Your assistance is appreciated 🙂

[AMBP73]

Many thanks ChiragGarg2512

[mlsx4]

Hi @AMBP73 

You can do:

Calculated_Column= IF(ISBLANK('YourTable'[Column]), "No", 'YourTable'[YourColumn])

Be aware, that you are calculating a new column. 

You can also use PowerQuery editor and replace directly nulls by No

[AMBP73]

Many thanks for both of the tips. 🙂

[mlsx4]

I'm glad it works. 

Don't forget to mark as solved the topic for other users which may need it

[ChiragGarg2512]

Try this measure:

measure = if(ISBLANK('table'[column]), "No", 'table'[column])