Forum Discussion
Replace NULL
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
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
Thanks!! I was just leaving the box empty; now that I've written 'null', it works!!
This worked great for me in 2020.
using only the word: null
Much appreciated
I can confirm that using the word null does the trick.
This also works for replace 'error' values as well. Click the drop down and it shows up.
Thanks
