Forum Discussion
Replacing all non-null values
Sorry.
Then I would probably add a conditional column
IF [column] = null then NULLELSE [column]
This calculated column will have your cleaned up values. Then you can hide the original one.
As far as I know the "Replace value" function does not have what you need.
Thanks Anonymous and Anonymous. I thought that it wasn't possible to do this using the replace all function. I'd prefer to not have to create new columns as I have so many of them. I think there may be a way to avoid having to replace values if I use a different query in a previous step, so I will try to work that out.
Thanks for your help.
Given that M does not have a "replace if different than"
https://docs.microsoft.com/en-us/powerquery-m/replacer-replacevalue
I don't believe you have options.
Unless of course you do it before importing data
In Excel you can use the wildcard "*" to identify non null cells and replace. But this doesn't work in BI
