Replace Blanks and Nulls with Unknown

[Viswaa123]

Hello All,

I am new to power BI

I have a field where I am having values like null and Blank like below

and I need to replace them with Unknown.

Could any one please how to do that with dax.

[halfglassdarkly]

Try removing the quote marks encasing Blank() i.e. { Blank() , " " }

Or ideally, I'd suggest handling this in PowerQuery before you load your data to Power BI. You can just use the Replace Values option under the Transform tab

To replace blanks with "Unknown": 

To replace nulls with "Unknown":

[Tahreem24]

@Viswaa123 Try this DAX:

Unknow Value = IF(Table[ColumnName] in { "Blank()" , " " }, "Unknown" , Table[ColumnName])

[Viswaa123]

Hi @Tahreem24 ,

Unfortunately its not working.