Nested If for Multi-Tier Grading Logic in Power Query M

Notes

Check thresholds from highest to lowest - the first condition that matches wins, so order matters.

Requirements

• A table with a numeric column to grade.

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.
• Conditional Column Based on List MembershipFlags rows where a column's value matches any item in a predefined list.
• 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 Nested If for Multi-Tier Grading Logic.