Group Sales people names from one column by creating new column with labels

[Anonymous]

I have about 100 salespeople in one column, I have to group them into new column by label them "MFG" and "FSI" 

What is the most effective way to do this? Use DAX? 

Creating a conditional column is tedious in this case.  

[Anonymous]

@amitchandak  many thanks for the quick solution. It solved my main problem. However, one issue remains. 
In this column, I have 100 sales people, where 10 belong to "MFG", another 10 belong to "FSI" and rest of 80 sales people belong to "General". 
For the MFG and FSI grouping, I used your instruction on youtube and it worked well. 
but for the rest of 80 people, is there any expression to group them using minimal formula. Want to avoid putting 80 names in this expression 🙂 Thanks

[amitchandak · Accepted solution]

@Anonymous , You have to create conditional column using if ow switch - https://www.youtube.com/watch?v=gelJWktlR80

also refer: https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/