Forum Discussion
Solved
change column value based on condition
Dear All, I have a table that looks like this: Code Value1 Value2 0001 100 200 0002 50 500 0003 10 20 0004 150 300 I'd like a condition in Power Query for which: ...
powerbricco add a replace value step and change it as shown below, do it for both value 1 and value 2
= Table.ReplaceValue(#"Changed Type",each [Value1],each if [Code] = 3 then [Value1] / 12 else [Value1], Replacer.ReplaceValue,{"Value1"})
powerbricco add a replace value step and change it as shown below, do it for both value 1 and value 2
= Table.ReplaceValue(#"Changed Type",each [Value1],each if [Code] = 3 then [Value1] / 12 else [Value1], Replacer.ReplaceValue,{"Value1"})
Dear parry2k , it does work perfectly!
May I ask you another advice?
Let's say I have a date column. Every time rows meet codes 001, 002, 003 and 0004, each Value1 should be replaced with month in date column. How can I write that?
Thank you a lot..