Category based on column

[mmoroni]

As a TV provider, we have differnt packages taht we offer customers.  2-23 is Basic, 24-103 is expanded. 200-300 is enhanced - and so on.

Besides writing a long nested if statement, is there a way I can say if column Ch# is between 2-23, label as "Basic", and so on?

[mmoroni]

Oh my!!!  You are a god amongst insects!   Thank you!!!

[amitchandak · Accepted solution]

@mmoroni , Create a new dax column and use

Switch(true(),
[Ch#]>=2 && [Ch#] <=23 , "Basic" ,
[Ch#]>=24 && [Ch#] <=103 , "expanded" ,
[Ch#]>=200 && [Ch#] <=300 , "enhanced" ,
"Other"
)