Forum Discussion
PowerQuery custom column returns "Active" when [reference column] contains any of the specified word
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
You may use List.Contains.
if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"
2 Replies
- xzmicheResolver I
You may use List.Contains.
if [Extract]="AG" and List.Contains({ "Service Stabilization", "Service Delivery"},[Work Status]) then "Yes" else "No"
- AnonymousNot applicable
Wow thanks i never thought funcitions like that works inside custom columns. Thank you