Clause IF equals to multiple values

[user2jenny]

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

[JorgePinho]

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]

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]

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

[user2jenny]

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]

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

[user2jenny · Accepted solution]

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