Forum Discussion
Replace Values using a condition
Hi Maz_0102 ,
In the same column, it can only replace the "N1" part, not the entire cell, like this:
Get the result.
If you want to replace the entire cell, you should add a custom column, then you can remove the original column.
Custom = if Text.Contains([Column1], "N1") then "London" else [Column1]Get the result.
Then remove column1 if you needed.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Hi
how can i do this in power query editor in power bi
sorry, where is the option for this and i want to keep same column but replace few valueas
Hi Maz_0102 ,
In the same column, it can only replace the "N1" part, not the entire cell, like this:
Get the result.
If you want to replace the entire cell, you should add a custom column, then you can remove the original column.
Custom = if Text.Contains([Column1], "N1") then "London" else [Column1]Get the result.
Then remove column1 if you needed.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.