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
6 Replies
- JorgePinho
Solution Sage
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?
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?
