DAX: New, Returning Customers and Base of Customers

[lprbi]

Hello,

Trying to get a calculated Measure that shows me the New Customers I get by month(for example).

Tryed several DAX samples but none have the effect.

Distinct Customers = My Active Customers in the month OK!

PreExisting Customers = My Base of Customers to the period

New Customers 

This one give me the result but only day by day, if I have any agreggate returns Blank:

DistinctCustomers =
DISTINCTCOUNT(CUSTOMERS[CUSTOMER_ID])
 
PreExisting Customers =
CALCULATE([DistinctCustomers];
DATESBETWEEN(ORDERS[ORDER_DATE];
0;
FIRSTDATE(ORDERS[ORDER_DATE])-1
)
)
 
NewCustomers = DistinctCustomers - PreExisting Customer

Please help!

Thank You

[greggyb · Accepted solution]

Please reference this DAX Patterns article for new and returning customers patterns.

 Let us know if you run into any specific problems.