Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Finding Duplicate "Recipes"

I have a dataset of products and their "recipe" or component blend. I need a way to find Products that have the same Components AND respective quantities of each component in the Product blend. I hav...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous is this what you are looking for? How big is your table?

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ThxAlot 

Thank you for the code. I tossed it into my dashboard, and

  1. it hits the resource limit so I will need to figure out a way to minimize that. Any recommendations?
  2. it pulls products with the same components but not at the same quantities. This is still actually very useful, but I would like to be able to find exact matches too.

Thanks!

  • ThxAlot's avatar
    ThxAlot
    Icon for Super User rankSuper User
    3 years ago

    Duplicate.pbix

     

    Measure tweaked and a bit more performant