Calculated Column that returns duplicate values

[Tmk123]

Hi, 

We have duplicate items in our ERP.  They all have the same Supplier SKU number but have a new Item number in the ERP.

The "Duplicate Item" column is my goal.

Sample Data:

Item	Supplier SKU	Duplicate Item
B406-038	4938Q318	40114
40114	4938Q318	B406-038
B422-365	MEL21	B401-276, 40036
B401-276	MEL21	B422-365, 40036
40036	MEL21	B422-365, B401-276

Ideally, I would like to create a calcuated column that can concatenate the duplicate value.  This information is held in the same table.  If that can't be done in a calcuated column, is creating a new table easier?

Thanks all!

[gmsamborn · Accepted solution]

Hi @Tmk123 

Would a column like this help?

Column = 
    CONCATENATEX(
        FILTER(
            'Table',
            [Supplier SKU] = EARLIER( 'Table'[Supplier SKU] )
                && [Item] <> EARLIER( 'Table'[Item] )
        ),
        [Item],
        ", ",
        [Item]
    )

Tmk123.pbix

[Tmk123]

Learned something new.  Thank you!!