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:   Ite...
  • 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

     

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!!