Grouping and expand column on DAX Studio

[wutthiphong_t]

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.

[lbendlin]

Chris Webb has a couple of blog posts on that topic

Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 1: Removing...

But you also want to ask yourself - do you really have to merge, or can you just join the tables in the data model?