Skip to main content

Power BI

Needs Votes

Power Query: Group By As New

Vote (5) Share
Amon Seagull's profile image

Amon Seagull on 29 Apr 2021 14:24:11

Merge and Append have useful alternatives where you can select "as new" to build a new query, instead of modifying the existing one.

How about the same option for Group By? Have I missed a reason why this is not needed?

Comments (1)
Amon Seagull's profile image Profile Picture

Colin Oakes on 03 Jun 2021 16:44:03

RE: Power Query: Group By As New

Yes, often I have many aggregations for the same data set, so have to duplicate then group. Really bad for memory and very tedius