Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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":
@Viswaa123 Try this DAX:
Unknow Value = IF(Table[ColumnName] in { "Blank()" , " " }, "Unknown" , Table[ColumnName])