IF DAX Statements

[Anonymous]

Hi, All I'm after help on this, 

I'm working on a list of suppliers of about 50 and I want to keep just 5 of the suppliers for a new column and make everyone else 'Others'

Please can I have a DAX formula that will output this? 

Many thanks.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

New Supplier Name =
IF (
    Sppliers[Supplier Name] IN { "Name1", "Name2", "Name3", "Name4", "Name5" },
    Sppliers[Supplier Name],
    "Others"
)