Pivot Without Aggregation in Power Query M

Notes

List.Max is only used to pick a value when a cell would otherwise be blank; with one row per group/category it simply returns that row's value.

Requirements

• A table with exactly one row per group/category combination.

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 ColumnsTurns unique values from one column into separate columns, aggregating another column.
• 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 Without Aggregation.