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