- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This topic has been covered well by the SQLBI team. Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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).
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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).
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-13-2019 12:28 PM | |||
03-16-2024 05:53 PM | |||
12-12-2019 09:44 AM | |||
09-09-2023 01:20 AM | |||
12-17-2024 02:44 AM |
User | Count |
---|---|
81 | |
78 | |
51 | |
38 | |
34 |
User | Count |
---|---|
92 | |
75 | |
53 | |
52 | |
45 |