Table.Distinct
Removes duplicate rows from the table.
function (table
as table, optionalequationCriteria
as nullable any) as table
Removes duplicate rows from the table
table
. An optional parameter, equationCriteria
, specifies which columns of the table are tested for duplication. If equationCriteria
is not specified, all columns are tested.Table.Membership
Remove the duplicate rows from the table.
Table.Distinct(Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "b"], [a = "A", b = "a"]}))
Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "b"]}, { "a", "b" })
Remove the duplicate rows from column [b] in the table
({[a = "A", b = "a"], [a = "B", b = "a"], [a = "A", b = "b"]})
.Table.Distinct(Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "a"], [a = "A", b = "b"]}), "b")
Table.FromRecords({[a = "A", b = "a"], [a = "A", b = "b"]}, { "a", "b" })
Last modified 4yr ago