Forum Discussion

COMtrac's avatar
COMtrac
Advocate I
9 years ago
Solved

Replace NULL

I am sure this is something simple I am missing but I can't for like of me solve it. i have table called INCIDENTS with a column in the table called PROVINCE. within that column there are Multiple e...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    Try this one dude.

     

    Create new calculated column using DAX.

     

    Column =     if (   isblank( 'Incidents' [Province]),  "Unspecifed" ,   'Incidents' [Province])

     

     

    This willhelp u if not let me know i will help u 

  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Alternatively in Power Query you can use Table.TransformColumns, so you don't need a new coumn:

     

    = Table.TransformColumns(Source, {"Province", each if _ is null then "unspecified" else _})

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi COMtrac,

     

    In addition, have you tried the "Replace Values" option within Query Editor? It should also work.:smileyhappy:

     

    1. Select the cell value you want to change(select null in this case) in Query Editor.

     

     

     

    2. Click "Replace Values" option under Home tab. Then you should be able to change null to "Unspecified" like below.

     

     

    Regards

dineshkumar_vrv's avatar
dineshkumar_vrv
Helper I
9 years ago

hi I want to fill the missing value as "Blanks" in the data so that I can display the list in slicer with one line item as Blanks, so how to fill the blanks with the word "Blanks" 

 

Thank you in advance 

Gazzer's avatar
Gazzer
Resolver II
8 years ago

I was having the same problem as I think you are having.

The issue seems to be that the text version of "null" is lowercase.

Here is what I did:

  • Use Format option to set the column values to UPPERCASE
  • Then use Replace Values to change NULL to null

 

It treats NULL as being text, but null as being an actual null value.

  • Sunnie's avatar
    Sunnie
    Helper I
    4 years ago

    so much easier , thank you!