Forum Discussion
Solved
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. custo...
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).
This topic has been covered well by the SQLBI team. Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/