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...
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!!!