topic Re: Dax to indicate "No" for blanks. in DAX Commands and Tips

Dax to indicate "No" for blanks.

AMBP73 — Wed, 20 Sep 2023 09:34:27 GMT

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 🙂

Re: Dax to indicate "No" for blanks.

ChiragGarg2512 — Wed, 20 Sep 2023 10:35:36 GMT

Try this measure:

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

Re: Dax to indicate "No" for blanks.

mlsx4 — Wed, 20 Sep 2023 10:24:54 GMT

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

Re: Dax to indicate "No" for blanks.

AMBP73 — Wed, 20 Sep 2023 10:58:48 GMT

Many thanks for both of the tips. 🙂

Re: Dax to indicate "No" for blanks.

AMBP73 — Wed, 20 Sep 2023 10:59:46 GMT

Many thanks ChiragGarg2512

Re: Dax to indicate "No" for blanks.

mlsx4 — Wed, 20 Sep 2023 12:58:54 GMT

I'm glad it works.

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