Forum Discussion
Help with Swith() True() Calculated Column with multiple Criterias
- 2 years ago
Please try the following modification:
User_name = SWITCH ( TRUE (), OR( CONTAINSSTRING ('Offering'[Offering], "Mobility"), CONTAINSSTRING ( [Offering], "Security" )) && NOT( CONTAINSSTRING ( [Approver], "L2" )) && NOT (CONTAINSSTRING ( [Region], "WW" )) && NOT (CONTAINSSTRING ( [Region], "Asia" )) && NOT (CONTAINSSTRING ( [Region], "ANZ" )), "Mike", "John" )Not sure if this is the final result you are looking for:
Hope this works.
Regards,
- 2 years ago
OMG!!! It worked perfectly! Thanks so much!!!
You Rock!
Mauri Castro
- 2 years ago
Glad to hear it worked for you. As for adding a third argument, simply "nest" them as you would an IF statement in Excel.
OR( Condition 3, OR ( Condition 1, Condition 2) ).Best Regards,
- 2 years ago
Excellent!... thanks again for the help!
Sorry, One more quick question. I see that the OR operator only allows for 2 Logical arguments... how can I include a 3rd argument? Should I enter a whole new string for the same User_Name?
Thanks again!
Mauricio
Glad to hear it worked for you. As for adding a third argument, simply "nest" them as you would an IF statement in Excel.
OR( Condition 3, OR ( Condition 1, Condition 2) ).
Best Regards,