Table.Distinct

Syntax

Table.Distinct(table as table, optional equationCriteria as any) as table

Description

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.

Reference Data

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query M Functions / Table Functions / Table.Distinct