Forum Discussion
How to Replace Null in the New Created Column
Hello Community,
I ve created a new custom column SLOM_KPIs and wrote the following formula in Power Query,
if [TM_NME] = "Information Technology" and [TSK_ASGN_NME] = "Some Name" and [SLOM_KPI_REFERENCE] = null then "-" else [SLOM_KPI_REFERENCE]
The Field SLOM_KPI_REFERENCE contains NULL or are blank in Power Bi Data View. I want to replace the NULLs or Blanks with a hypnen sign.
Help Required.
1 Reply
- Greg_Deckler
Community Champion
Tayyab That formula looks good to me, what is the issue? Are you looking for this?
if [TM_NME] = "Information Technology" and [TSK_ASGN_NME] = "Some Name" and ( [SLOM_KPI_REFERENCE] = null or [SLOM_KPI_REFERENCE] = "" ) then "-" else [SLOM_KPI_REFERENCE]
