Review and rank items

johnstan

New Member
Joined
Jan 11, 2013
Messages
8
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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Ozeroth

Active Member
Joined
Dec 14, 2013
Messages
264
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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,133,532
Messages
5,659,368
Members
418,499
Latest member
mbcmel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top