Forum Discussion

Sowmyak's avatar
Sowmyak
New Member
2 years ago

replace value #value into 0

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 gett...
Learning Rooms
Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

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 _}})