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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.

Top Solution Authors