The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 @wmf_07 ,
the case is very similar to:
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Count-New-Client/m-p/3527562
User | Count |
---|---|
13 | |
8 | |
7 | |
6 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |