Distinct count of customers registered by first date

[Anonymous]

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:)

[BA_Pete · Accepted 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