Forum Discussion
Solved
Remove rows based on second key in another column
Hello, I need help filtering out data in a large dataset. I have a table that looks like this: Column1 Column2 Value1 Value2 Value3 35 XY-23 Prod1 A 1231 ...
gr = Table.Group( your_tbl, "Column2", {"x", (x) => [a = List.Max(x[Column1]), b = Table.SelectRows(x, (w) => w[Column1] = a)][b]}), z = Table.Combine(gr[x])
Many thanks to AlienSx and PhilipTreacy for your quick responses. Both solutions work perfectly.