Forum Discussion

PowerBILP's avatar
PowerBILP
New Member
2 years ago

Cross selling analysis

Hello PowerBI community,

 

I'm trying to perform a cross selling analysis but I cannot find online a solution that fits my needs.


I have a table that contains 3 columns:

-Transaction ID 

-Product Name

-Quantity

 

My wish is to have a matrix with products in rows and columns that shows how many time the same products have been bought together in the same transaction (I attach an example). 

Could you please tell me how to proceed and if possible to create an example in PowerBI?

 

Many thanks in advance!

 

Need Help

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    Hi PowerBILP 

    The best article I can suggest is:

    https://www.daxpatterns.com/basket-analysis/

     

    This article includes a PBIX to download, so I would suggest looking at that first.

     

    In the terminology of the article, a visual similar to the one in your screenshot could be produced in a matrix using:

    • Column(s) of 'Product' on rows
    • Column(s) of 'And Product' on columns
    • # Orders Both as the measure

     

    Does that help?

    Regards