Hi there,
I working on table that more than 10M rows, I try to grouping and expand column in Power Query by test table (1M rows) by this:
= Table.Group(#"Added Combine Column", {"CombineXY"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Partition", each Table.AddIndexColumn(_, "MSindex",1,1) , type table [X_Col=nullable text, Y_Row=nullable text, TOTALVOLUME=nullable text, TRUEVERTTHK=nullable text, TRUETHK=nullable text, XXX=nullable text, CombineXY=text, MSindex=text]}})
= Table.ExpandTableColumn(#"Grouped Rows", "Partition", {"X_Col", "Y_Row", "TOTALVOLUME", "TRUEVERTTHK", "TRUETHK", "XXX", "MSindex"}, {"X_Col", "Y_Row", "TOTALVOLUME", "TRUEVERTTHK", "TRUETHK", "XXX", "MSindex"})
That good for test table but doesn't work when apply to working table, run very long time and show 'memory not enough'. May I grouping and expand column on the DAX Studio and how to use it.
