Forum Discussion
Replace Values using a condition
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
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.
3 Replies
you can do this over power query: https://support.microsoft.com/en-us/office/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e9cf721,
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
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 _ kalyjIf this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
