Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
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,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
This topic has been covered well by the SQLBI team. Take a look at this article:
https://www.daxpatterns.com/new-and-returning-customers/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
52 | |
38 | |
34 |
User | Count |
---|---|
95 | |
69 | |
55 | |
52 | |
46 |