PQ - Distinct vs Unique

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

---