How to use Switch on different columns

[Anonymous]

Hi,

I am a beginner 🙂

I need to nest several switch.

Here is the idea (i am creating a new column) :

- If in column A there is the expression "Smart", then return "Idiot", if there is "Green", the return "Color", else return Column A. Up to here i can manage  SWITCH(Column A;"Smart";"Idiot";"Green";"Color";"Column A")

- But here is the thing, I would like, in the same created column, to test the column B also. 

Maybe you have a solution?

[Mariusz]

Hi @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.

[Anonymous]

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 · Accepted solution]

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.

[Anonymous]

Thank you !!