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
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
Solution Sage
Solution SageHow do you choose which of the three names "Jimmy" "Alex" "John" to write in each case?