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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

PowerQuery custom column returns "Active" when [reference column] contains any of the specified word

I have 2 columns

ExtractWork Status
AMService Stabilization
AGService Stabilization
AGIn progress
AGService Delivery

 

Now for the custom column I'm trying to return "Yes" if [Extract] = "AG" and [Work Status] = *to any of these words {Service Stabilization, Service Delivery}

 

ExtractWork StatusActive
AMService Stabilization 
AGService StabilizationYes
AGIn progress 
AGService DeliveryYes

 

How do put multiple words as a criteria on [Work Status]

I tried doing 

if [Extract] = "AG" and [Work Status] = { "Service Stabilization", "Service Deliver"} then "Yes" else""

I also tried

If [Extract] ="AG" and [Work Status] = "Service Stabilization" or "Service Delivery" then "Yes" esle ""

 

both only seems to output "Yes" *ONLY when [Work Status] is Service Stabilization, what might be the correct syntax for it

 

1 ACCEPTED SOLUTION
xzmiche
Resolver I
Resolver I

You may use List.Contains.

if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"

View solution in original post

2 REPLIES 2
xzmiche
Resolver I
Resolver I

You may use List.Contains.

if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"

Anonymous
Not applicable

Wow thanks i never thought funcitions like that works inside custom columns. Thank you

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.