I have a SALES table with a products marked as a true/false (true marked as '1') showing if a specific product was sold on a specific date.
I have a COMBOS table with a wide range of combinations of products. It ranges from 1 product up to 5 different products, in any order.
I need to compare each combination row to the sales table and get a list of matched dates for each combination.
For example- I need a list of every time the PANTS and WATCHES combination was sold together, regardless if anything else was sold on the same date or not. SO- the resulting list would include:
2/19/2019 *- Notice there was also shoes sold on this date, but that doesn't matter, I still need it included in the list since PANTS and WATCHES were still sold together on this day.
I've been using power query to do this since the dataset is large. Can someone tell me how to manipulate the data so I can either pivot or merge and get the resulting lists of dates?