Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!