Pivot Columns in Power Query M

Notes

Replace List.Sum with another aggregation (List.Average, List.Max, and so on) if needed.

Requirements

• A long-format table with a column to pivot and a column to aggregate.

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

• Pivot Without AggregationPivots a column into new columns while keeping the raw values, for cases where each group only has one row per pivoted category.
• Unpivot Month ColumnsUnpivots only the columns that look like month names, leaving key columns like ID or Region untouched.
• Transpose Table and Keep HeadersFlips rows and columns while preserving the original column names as a new first row.
• Combine Rows into One Cell (Comma-Separated List)Groups rows and concatenates a column's values from each group into one comma-separated text value.
• Split One Row into Many by DelimiterSplits a delimited text value in one column into multiple rows, duplicating the rest of the row's values.
• Unpivot ColumnsTurns wide columns (like one column per month) into Attribute/Value pairs.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Pivot Columns.