Identifying and listing duplicates across multiple columns

Question

I am looking for a solution either in Power Query or in DAX to be able to identify customer orders which are placed by error more than once.&nbsp;A customer order (Order ID) is considered 'duplicate' if there is another Order ID with the:- same Order Date +- same Customer Reference +- same List of Materials&nbsp;+- same Order quantities for each material.&nbsp;It is important that one order usually consist of multiple Material codes and we want to find 'duplicate' orders only if the whole list of material and order quantities are the same.&nbsp;&nbsp;&nbsp;Any help appreciated.&nbsp;

tamerj1 · Answer

Hi&nbsp;BLB&nbsp;Please try
Duplicate Orders =
CALCULATETABLE (
    VALUES ( Orders[Order ID] ),
    FILTER (
        SUMMARIZE (
            Orders,
            Orders[Order Date],
            Orders[Customer Reference],
            Orders[List of Materials],
            Orders[Order Qty]
        ),
        COUNTROWS ( CALCULATETABLE ( Orders ) ) &gt; 1
    )
)

Forum Discussion

Related content

Identifying duplicates

Identifying Duplicates

Identify duplicates

Identifying Duplicates accross Multiple Columns

Identifying duplicates