Forum Discussion

Tmk123's avatar
Tmk123
Helper II
2 years ago
Solved

Calculated Column that returns duplicate values

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:

 

ItemSupplier SKUDuplicate Item
B406-0384938Q31840114
401144938Q318B406-038
B422-365MEL21B401-276, 40036
B401-276MEL21B422-365, 40036
40036MEL21

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's avatar
    gmsamborn
    2 years ago

    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

     

2 Replies

  • gmsamborn's avatar
    gmsamborn
    Super User
    2 years ago

    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's avatar
      Tmk123
      Helper II
      2 years ago

      Learned something new.  Thank you!!