Forum Discussion
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...
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
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 _})
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
