Forum Discussion
How to use Switch on different columns
Hi Anonymous,
Please see the below.Column = SWITCH( TRUE, YourTable[Column A] = "Smart", "Idiot", YourTable[Column B] = "Tiger", "Animal", YourTable[Column B] )
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionHi Anonymous
You Can use SWITCH with TRUE as a first argument like below.
Column =
SWITCH(
TRUE,
YourTable[Column A] = "x" && YourTable[Column B] = "y", "x AND y",
YourTable[Column A] = "x" || YourTable[Column B] = "y", "x OR y",
"otherwise W"
)
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Mariusz ,
thank you for your answer, but maybe I wasn't clear enough.
In the new column, I need evaluate several expression at once and return different results depending on the value.
So, if in column A there is the value "Smart", then return "Idiot" or if in Column B there is the value "Tiger", then return "Animal". Else, column B.
Or maybe I didn't understand your answer :)
Thank you in advance !
- Mariusz
Hi Anonymous,
Please see the below.Column = SWITCH( TRUE, YourTable[Column A] = "Smart", "Idiot", YourTable[Column B] = "Tiger", "Animal", YourTable[Column B] )
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you !!