Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to use Switch on different columns

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?

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.

4 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Mariusz
        Icon for Community Champion rankCommunity Champion
        7 years ago

        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.