DISTINCT (table)

DISTINCT (table) Returns a table by removing duplicate rows from another table or expression.





table – The table from which unique rows are to be returned. The table can also be an expression that results in a table.

Return Value

A table containing only distinct rows. There is another version of the DISTINCT function, DISTINCT (column), that takes a column name as input parameter.

Reference Data


DAX Functions / Filter Functions / DISTINCT (table)

Date and Time Functions Filter Functions Financial Functions Information Functions
Logical Functions Math and Trig Functions Other Functions Parent and Child Functions
Statistical Functions Text Functions Time Intelligence Functions

Power Query M Functions

Accessing Data Functions Binary Functions Combiner Functions Comparer Functions Date functions DateTimeZone functions
Duration Functions Error handling Functions Expression Functions Function Values List Functions Lines Functions
Logical Functions Number Functions Record Functions Replacer Functions Splitter Functions Table functions
Text Functions Time functions Type functions Uri functions Value functions