Forum Discussion
Help with Swith() True() Calculated Column with multiple Criterias
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,
OMG!!! It worked perfectly! Thanks so much!!!
You Rock!
Mauri Castro
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,
Excellent!... thanks again for the help!
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,
OMG!!! It worked perfectly! Thanks so much!!!
You Rock!
Mauri Castro
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,