Forum Discussion
Solved
Category based on column
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 , 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"
)
2 Replies
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"
)Oh my!!! You are a god amongst insects! Thank you!!!
