Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |