Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello guys
I'm somewhat new to PowerBI. Apologies in advance if this question or a similar one has been asked already. Basically, as the title suggests, I'm attempting to find out how often two (or more) items are sold together in a single order.
Additionally, this will then be used to determine whether two items should be moved closer together location-wise in the warehouse.
Bellow is a screenshot of a sample of the data:
Location = the location of the ware in the warehouse
WareID = the ID of the ware
Order number = the order
I'm thinking that these are the only collumns that are relevant, but let me know if additional data is needed, etc.
Best regards,
Sebastian
Solved! Go to Solution.
@Sgb1201 , I think you are looking for Market Basket Analysis
https://finance-bi.com/power-bi-basket-analysis/
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.daxpatterns.com/usecases/market-basket-analysis/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/
@Sgb1201 , I think you are looking for Market Basket Analysis
https://finance-bi.com/power-bi-basket-analysis/
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.daxpatterns.com/usecases/market-basket-analysis/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/
This is exactly what I'm looking for. Thanks for replying!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |