Conditional Column Based on a Value Range in Power Query M

Notes

M has no built-in BETWEEN keyword - chaining >= and <= with and is the standard way to express a range.

Requirements

• A table with a numeric column to test against a range.

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

• Age Group / Number Banding (Buckets)Adds a category column that buckets a numeric value into labeled ranges, such as age groups.
• Add a Conditional ColumnAdds a column whose value depends on an if/then/else condition.
• 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.

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 a Value Range.