Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help with a multicase SWITCH statement

The logic I am attempting to follow is:     If column 1 equals True then "Some Designation 1" If column 2 equals True then "Some Designation 2" If Column 3 equals "Some Value1" AND Column 4 eq...
v-anabat's avatar
v-anabat
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi, 

 

please check if the below formula works 

Result = SWITCH(TRUE(),
                'Table'[Column 1] = TRUE(), "Some Designation 1",
                'Table'[Column 2] = TRUE(), "Some Designation 2",
                'Table'[Column 3] IN {"1","2"} &&  'Table'[Column 4] IN {"1","2","3","4","5"}, "Some Designation 3",
                "Undefined"
)
Based on your explination, I assumed data set/result as present in below sceenshot.
If it is different provide the same dataset