Distinct vs Unique
Source Unique Distinct List _____ List _____ List Mark Mike Mark John Adam John Mike Joe Mike Adam Chris Adam John Joe Mark Chris Mark Joe Chris
Unique
DistinctCode:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Group = Table.Group(Source, {"List"}, {{"Count", each Table.RowCount(_), type number}}), Filter = Table.SelectRows(Group, each ([Count] = 1)), Unique = Table.RemoveColumns(Filter,{"Count"}) in Unique
Code:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Group = Table.Group(Source, {"List"}, {{"Count", each Table.RowCount(_), type number}}), Distinct = Table.RemoveColumns(Group,{"Count"}) in Distinct




Bookmarks