Conditional Column Based on List Membership in Power Query M

Notes

Update TargetRegions with the values you want to match against - this scales better than a long chain of or conditions.

Requirements

• A table with a column to check against a fixed set of values.

How to use this snippet

1. In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
2. Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
3. Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

• Add a Conditional ColumnAdds a column whose value depends on an if/then/else condition.
• Conditional Column Based on a Value RangeFlags rows whose value falls between two thresholds, using Power Query's between-style comparison.
• Nested If for Multi-Tier Grading LogicAssigns a letter grade or tier based on several ordered thresholds.
• Add a Boolean Flag Column from a ConditionAdds a simple true/false column instead of text, which is cheaper to filter and aggregate on later.
• Combine AND/OR Logic in a Conditional ColumnBuilds a conditional column that checks multiple columns together using and/or with parentheses.
• Check for Null Safely Inside a ConditionExplicitly tests for null before comparing, since comparing a value to null directly can behave unexpectedly in M.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Conditional Column Based on List Membership.