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
Code:
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
Distinct
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