Replacing values of null and blank do not work as expected in Power Query

[Anonymous]

Hello Power Query Champions,

I am struggling to replace blank and null values in my table using Power Query.

This is the code that I have used referring various blogs:

Custom1 = Table.ReplaceValue(#"Replaced Value18",each [Landing Page.1],each if [Landing Page.1]= null then "a" else if [Landing Page.1] = " " then "P" else [Landing Page.1],Replacer.ReplaceText,{"Landing Page.1"})

However nothing happens.

Is there anything that I am doing wrong here?

The text I am trying to replace is in Text format

[Vera_33 · Accepted solution]

Hi @Anonymous 

Please have a try

 Custom1 = Table.TransformColumns( #"Replaced Value18",{"Landing Page.1", each if _=null then "a" else if _=" " then "P" else _})

[Anonymous]

Hi Vera,

It's working fine for the string however it's not working in case I wanat to pass the field name.

[Vera_33]

Hi Nikhil,

So what do you want to do with the column "Landing Page.1"? I was modifying your original code.

[Anonymous]

Thanks Vera.I have achieved what I wanted.