BI and PQ DATA TIPS AND TRICKS

How to Remove Duplicates in Power Query M (Complete Guide)

Basics for Removing Duplicates

So, how can you remove duplicates using the Power Query Editor? Under the hood, the operation uses the Table.Distinct function to remove duplicates. The syntax for the function is as follows:

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