Quick Tip - Replace value with another column in Power Query

To replace a value with another value is super easy in Power Query. However, if you want to replace a value with the corresponding content in another column, it's not that straight-forward in Power Query. Most of the time, we could add a conditional column, and then remove the original column. It works, but with more steps.

In this video, I am going to show you now to do that with Replace values, followed by a simple editing in the formula generated.

I hope you like it. If you do, please give a thumb up, share and subscribe my channel. 😉

#PowerQuery
#ReplaceValue

[johnharker]

Just what i was looking for, thank you!

[H-HQ]

I'll just leave this here for anybody who might need it. Was looking for nearly half a day before I finally got it working:

= Table.ReplaceValue(#"Previous-Step", each [#"Column in which values need to be replaced"], each which holds URLs in which I only need a certain recurring keyword"], "/", "-", 5, 0), Replacer.ReplaceValue, {"Column in which values need to be replaced"})

[kirkyit]

D'oh, I have achieving this result by the longer add-custom-column method. This is much more efficient and elegant!

[farisazrai]

This will not work if you have a special character like $,
change the column name and it will be fine