replace value #value into 0

[Sowmyak]

Hi Team,

Please can someone suggest a solution for the following query.

= Table.ReplaceValue(#"Changed Type","#VALUE!","0",Replacer.ReplaceText,{"price (per unit)"})

why the values are not getting updated as 0. 

rgds,

sowmya

[Kaviraj11]

If the values are not updating as expected, there could be a few reasons::

1. Ensure that the column “price (per unit)” is formatted as text. If it’s not, the replacement might not occur because Replacer.ReplaceText is designed to work with text values.

2. The Replacer.ReplaceText function looks for an exact match. If there are leading or trailing spaces or other non-printable characters around #VALUE!, the function won’t find a match to replace.

3. or else try this 

= Table.TransformColumns(#"Changed Type", {{"price (per unit)", each try if _ = "#VALUE!" then "0" else _ otherwise _}})