In our previous article, Identifying Customer Buying Patterns in Power BI—Part 1, we described the customer purchase product frequency. In this article, we will be conducting an advanced analysis in Power BI via a market-based analysis (MBA) technique called basket analysis. Therefore, we will be creating the basket analysis DAX formula. Part 3 of identifying customer buying patterns in Power BI will cover metrics related to the « association rule ». The data in this article, Power BI Auto-Detect Relationship Failure, has already been produced.
What is Basket Analysis?
Basket analysis is used mostly for identifying customer buying patterns as a data