Forum Discussion
Which row will keep Table.Distinct(Table, {"Column"})
Hi Belin ,
did you buffer the sort operation? (see here: Bug warning for Table.Sort and removing duplicates... - Microsoft Power BI Community )
that's interesting, thank you.
At the end I used this
https://www.youtube.com/watch?v=hidJ5T_DYQ0
works like a charm
but I jsut noticed that in the notes she added a second better method, which I didn't have the time to try yet
Hello,
Just to notice that using grouping might lead to a huge computation time. Furthermore, if you want to keep only one row, using Max as the aggregation function might not work if there are multiple rows with the max value. Therefore you may think to use Table.FirstN as an aggregation function: same issue, it would burst your memory.
Therefore I think using Table.Buffer is the best idea when it comes to sorting
Best
