Forum Discussion
repeat customers
i want to calculate repeat customers and show in below matrix, please see below the pbix file with sample data
repeat customers are those customers who follow below two criterias
critera:
1. customers who purchased more than 1 time in the same year, example , mike purchased 2 times in 2023
2. customers who purchased in consecutive year, example , david purchased in 2022 and 2023 as well so david is repeat customer
pbix file: https://drive.google.com/file/d/1XFqq6R1azA2YUn9lubKmZI1hv0nBU3-y/view?usp=drive_link
This topic has been covered well by the SQLBI team. Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/I don't waste too much delving into the spaghetti-like data model; but give you some hint.
Interpret the criteria into DAX logics this way,
- find all customers in certain year from column/country from row;
- among all customers in step 1, find those who place at least 2 orders during the period of 2 years (certain year and previous year).
2 Replies
This topic has been covered well by the SQLBI team. Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/I don't waste too much delving into the spaghetti-like data model; but give you some hint.
Interpret the criteria into DAX logics this way,
- find all customers in certain year from column/country from row;
- among all customers in step 1, find those who place at least 2 orders during the period of 2 years (certain year and previous year).