CODEWITHSUNDEEP
excel-formulapowerquerypowerpivotpowerbi-desktop
Ben Cruz
Ben Cruz

Reputation: 55

Replace value in one column with another

I have some doubts, i want to replace the values in column for the values of the other one, i have my query like this = Table.ReplaceValue(#"Renamed Columns1", each ["Alcance-Canal"], null , Replacer.ReplaceValue,{"CANAL/ES"})

however it still doesn't work, could you please assist me?

Regards

Upvotes: 1

Views: 91

Answers (1)

horseyride
horseyride

Reputation: 21318

Easiest thing to do is add a custom column with formula

= if [columnname] = "something" then [columnname] else [othercolumnname]

or

= if [columnname] = "something" then "anotherthing" else [othercolumnname]

Upvotes: 1

Related Questions