Add a Boolean Flag Column from a Condition in Power Query M

Notes

A logical column is smaller and faster to filter on than an equivalent text column like "Yes"/"No".

Requirements

• A table with a date or datetime column to compare.

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.
• Nested If for Multi-Tier Grading LogicAssigns a letter grade or tier based on several ordered thresholds.
• Flag OutliersFlags rows whose numeric value falls outside a set number of standard deviations from the column's average.
• 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 Add a Boolean Flag Column from a Condition.