Forum Discussion
Which row will keep Table.Distinct(Table, {"Column"})
Hi colleagues, Which row will keep Table.Distinct(Table, {"Column"}) for the rows with the same values in the "Column": First row? Last row? Random row? MS documentation has no explanation abo...
Here's another article about this topic you might find helpful.
https://docs.microsoft.com/en-us/power-query/commonissues#preserving-sort
I just wanted to let you know I've updated the docs page above based on this thread. Hopefully it's more relevant/helpful now.