29 - Replace the values in a column on a condition (Power Query)

Say you have a column where you need to change the value based on a condition. The "normal" way is to create a new calculated column with your logic. This results in multiple steps where you create a new column, delete the old, rename the new column, and change the position of columns.
That's too many steps.

I show how to take the normal "Replace values/text" function, and have it loop through your column and change the value based on a condition.
This avoids needing to create a new column and reordering columns, which can introduce an error.

00:00 Intro
00:42 Normal method
02:25 Replace method