Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have 2 columns
| Extract | Work Status |
| AM | Service Stabilization |
| AG | Service Stabilization |
| AG | In progress |
| AG | Service 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}
| Extract | Work Status | Active |
| AM | Service Stabilization | |
| AG | Service Stabilization | Yes |
| AG | In progress | |
| AG | Service Delivery | Yes |
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
Solved! Go to Solution.
You may use List.Contains.
if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"
You may use List.Contains.
if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"
Wow thanks i never thought funcitions like that works inside custom columns. Thank you
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 16 | |
| 14 | |
| 14 | |
| 10 | |
| 9 |