Forum Discussion

user2jenny's avatar
user2jenny
Frequent Visitor
3 years ago
Solved

Clause IF equals to multiple values

Hello,   I'am wondering how can i do this:   = Table.AddColumn( if [A] = "1" then List.Contains({"B" , "C","D" }) else null)   it doesn't work with my formula
Need Help
Show and Tell
Tips and Tricks
  • user2jenny's avatar
    user2jenny
    3 years ago

    I think i've solved this, i've just created a table for that

JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

Hello user2jenny ! I'm sorry but it wasn't clear to me what was your desired output. Can you explain in a different way and possibly provide an example?

user2jenny's avatar
user2jenny
Frequent Visitor
3 years ago

Hello JorgePinho ,

 

I want to add a custom column in Power query with one same condition but equals to multiple values, for example(IF you="boy", then "Jimmy" or "Alex" or "John")

Hope my explication is better.

  • JorgePinho's avatar
    JorgePinho
    Icon for Solution Sage rankSolution Sage
    3 years ago

    I can't understand what you want to write in the custom column. You want to write a list of those names?

    • user2jenny's avatar
      user2jenny
      Frequent Visitor
      3 years ago

      I want the function returns these values in the custom column, like below:

       

      column 1 | Custom column 2

      boy          |   Jimmy    

      boy          |   Jimmy

      boy           |   Alex

      boy           |   John

      boy           |   John

       

      • JorgePinho's avatar
        JorgePinho
        Icon for Solution Sage rankSolution Sage
        3 years ago

        How do you choose which of the three names "Jimmy" "Alex" "John" to write in each case?