Replace several values with three from same column

[Tabita88]

Hello,

I struggle with a situation and I need your help to understand how to solve it.

I have a query in Power BI and I want to replace information from one column as mention below. I know how to use Replace button but I have 60 values to replace with "Others" and I was hoping that you have a shortcut for me:)

For example, I don't know if there is formula I can use to replace several catogories from one column to a single category, for example: replace "Testing team", "Application team" with "Others".

Category	New category
Support Europe	local team
Global support	L2
Testing team	others
Application team	others
Improvement team	others

Thank you in advance.

Tabita

[tamerj1]

Hi @Tabita88 
With power query you can perform left outer join and retrieve the new values, you can then add a conditional column where if the new value is null return the old of and if not return the new one.

With DAX you can have 'Repalcements' as a lookup table tp retrieve the new name whenever needed.

[amitchandak]

@Tabita88 , A new column

Switch(True() ,

[Category] = "Support Europe" ,"local team",
[Category] = "Global support" ,"L2",

"Others")