Age Group / Number Banding (Buckets) in Power Query M

Adds a category column that buckets a numeric value into labeled ranges, such as age groups.

Conditional LogicBeginnerbandingbucketsage grouprange

Power Query M code

let
    Source = YourTable,
    AddedBand = Table.AddColumn(Source, "AgeGroup", each
        if [Age] < 18 then "Under 18"
        else if [Age] <= 34 then "18-34"
        else if [Age] <= 54 then "35-54"
        else "55+",
        type text)
in
    AddedBand

Notes

Adjust the thresholds and labels to match the bands your report actually needs.

Requirements

A table with a numeric column to bucket.

How to use this snippet

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).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Age Group / Number Banding (Buckets).