Review and rank items

[johnstan]

Hi, I am not sure if I am on the right Forum or this is even possible using Excel. Although I am not sure what power query or power pivot is I was wondering if they could be the tool for me?

I have a list of items that I have supplied and more often or not I supply other items as well to users.
I want to review any random item and have Excel list and rank other items that were supplied at the same time as the search criteria.

My train of thought is based on the Amazon idea of when someone buys something it suggest other items that were bought alongside the original.

Would this be better suited to Access? I am really looking to be pointed in the right direction before I waste too much time trying to achieve something that is not possible.

Thank you in advance for any help / suggestions you can give.

Regards
John

 

[Ozeroth]

Hi John,

Have a look at Basket Analysis on DAX Patterns:
Basket Analysis – DAX Patterns

specifically the section "Products More Likely Bought with Another Product"

Is this along the lines of what you are wanting to do?

Regards,
Owen