Replace field values if matched

Question

How to replace field value if a condition is met, code == "200" then change the existing value +100 to field values.

I have a list of transactions made by users to book slots, but due to some error, the amount for a few transactions changed, so I want to replace or update those values.

Answer 1

Create a custom column in Power Query Editor. Use this column instead of actual column for calculations.

if [Code] == 200 then [Sales] else [sales]+100.

I hope this works!