Add a Conditional Column in Power Query M

Notes

Replace Amount and the thresholds with your own column and business rules.

Requirements

• A table with a numeric column to branch on.

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

• 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.
• 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 Add a Conditional Column.