Replace Values using a condition

[Maz_0102]

Hi

I want to repace some values in a column based on part of the value they all share

as an exampke, I want to replace all these values from the filter to "London" on the condition if they contain "N1"

can anyone please help

[StefanoGrimaldi]

you can do this over power query: https://support.microsoft.com/en-us/office/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e...

or create a new column using a condition like 

New column = if(contains(column name; "CN 03", value if true, value if false)

contains function: https://docs.microsoft.com/en-us/dax/contains-function-dax 

[Maz_0102]

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

[v-yanjiang-msft · Accepted solution]

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.