Forum Discussion
Solved
Replacing all non-null values
This is probably a fairly simple query, but I cannot work out how to do it. How can I replace all values that are not null across multiple columns with the word Yes. Thank you!
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.
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