Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Clause IF equals to multiple values



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

View solution in original post

Solution Sage
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.

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


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

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors