Forum Discussion
COMtrac
Advocate I
9 years agoReplace 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...
MarcelBeug
Community Champion
9 years agoAlternatively 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 _})
nahomzw
6 years agoFrequent Visitor
How can I apply the same technic if the data type is decimal? Thank you