Forum Discussion
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
I think i've solved this, i've just created a table for that
JorgePinho
Solution Sage
Solution SageHello 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?
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?
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