Replacing string with null in power query

[Anonymous]

Hey there

I'm trying to replace a text string in power query with power query's standard null value. However, whatever the text I try to replace with the null all I get is the same value all over (as show in the following image).

Why I do not simply replace it with ""? Because when I do so, I get two kind of blank values in my dataset:

I've came across with this post, but it does not fix my problem because I have to replace several values at once.

Do someone knows how to do that replacement?

Thanks in advance.

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

The second part you mentioned is not empty. This means that you have at least one space character in your text.

If possible, you should first replace ' ' with '' as follows:

= Table.ReplaceValue(#"Renamed Columns"," ","",Replacer.ReplaceText,{"Column3"})

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , null will be shown as blank in DAX. Sorry, but bot sure what is the issue here?