Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I want to obtain how many customers are repeated per month. I want the total count of customers (customer code) that is present both in January and February to be displayed in Feb then the total count of customer ID that is present both in Feb and March in March and so on. How do I solve this problem?
hi @Anonymous ,
the case is very similar to:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Count-New-Client/m-p/3527562
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 14 | |
| 7 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 29 | |
| 18 | |
| 17 | |
| 11 | |
| 10 |