Combine AND/OR Logic in a Conditional Column in Power Query M

Notes

Parentheses control evaluation order just like in Excel - group the or condition before combining it with and.

Requirements

• A table with the columns used in the conditions.

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

• Check for Null Safely Inside a ConditionExplicitly tests for null before comparing, since comparing a value to null directly can behave unexpectedly in M.
• 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.
• Conditional Column Based on List MembershipFlags rows where a column's value matches any item in a predefined list.
• 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.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Combine AND/OR Logic in a Conditional Column.