Table.Distinct

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Removes duplicate rows from a table, ensuring that all remaining rows are distinct.

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

ArgumentDescription
tableThe Table to modify.
optional equationCriteriaAn optional value that specifies how to control comparison between the rows of the table
Table.Distinct(  
  
    Table.FromRecords(  
  
{  
  
    [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],  
  
    [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0],  
  
    [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0],  
  
    [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0],  
  
    [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0],  
  
    [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0],  
  
    [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25],  
  
    [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0],  
  
    [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]  
  
}  
  
), "CustomerID")  

OrderIDCustomerIDItemPrice
11Fishing rod100
32Fishing net25
43Fish tazer200
75Bait3.25
96Bait3.25
Show: