Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need some help counting customers registered in my database. Have around 100.000 new customers per year, and would like to see some trends like YTD vs PY YTD and so on.
The table looks like this:
Index | CustomerID | RegistrationDate | DistinctRecord |
1 | 100 | 20.10.2020 | 1 |
2 | 100 | 21.11.2020 | 0 |
3 | 100 | 22.11.2020 | 0 |
4 | 101 | 20.11.2020 | 1 |
5 | 102 | 20.11.2020 | 1 |
I have used the following calculation
All customers = DISTINCTCOUNT('Customertabel'[CustomerID])
This gives me the number of unique customers.
My problem is when I would like to calculate Number of Customers created this month vs. last month and so on.
Thanks for any help:)
Solved! Go to Solution.
Hi @Anonymous ,
I may be oversimplifying your requirement, but the following measure should do as you describe:
_noofCustomers = DISTINCTCOUNT(yourTable[Customer ID])
Using this measure along with a properly-marked calendar table and a relationship between calendar[Date] and yourTable[Registration Date] will get you started being able to visualise new customer registrations over time and so on.
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
I may be oversimplifying your requirement, but the following measure should do as you describe:
_noofCustomers = DISTINCTCOUNT(yourTable[Customer ID])
Using this measure along with a properly-marked calendar table and a relationship between calendar[Date] and yourTable[Registration Date] will get you started being able to visualise new customer registrations over time and so on.
Pete
Proud to be a Datanaut!
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |