Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors