Categories
October Surprise 2016

What order do Duplicates get Removed in Power Query?

Table.Distinct (Table.StopFolding (#”Sorted Rows”), {DuplicateColumn”}) and not Table.StopQueryFolding as this won’t be recognised although Microsoft documentation refers to this functionality as Stop Query Folding.