repeat customers

[powerbiexpert22]

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

[jdbuchanan71 · Accepted solution]

@powerbiexpert22 

This topic has been covered well by the SQLBI team.  Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/

[ThxAlot · Accepted solution]

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,

1. find all customers in certain year from column/country from row;
2. 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).

[jdbuchanan71 · Accepted solution]

@powerbiexpert22 

This topic has been covered well by the SQLBI team.  Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/