I’ve used the following formula from the New Customer Analysis video
New Customers Sales = VAR CustomerTM = VALUES('Order Intake'[Cust. ID]) VAR PriorCustomers = CALCULATETABLE(VALUES('Order Intake'[Cust. ID]), FILTER(ALL('Calendar'), 'Calendar'[Date] > MIN('Calendar'[Date])-750 && 'Calendar'[Date] < MIN('Calendar'[Date]))) RETURN CALCULATE([Total Orders],EXCEPT(CustomerTM,PriorCustomers))
There is a filter on the page for 2018 - ie only new customers in 2018 to appear
This part of the filter:
‘Calendar’[Date] > MIN(‘Calendar’[Date])-750 &&
‘Calendar’[Date] < MIN(‘Calendar’[Date])))
I thought was creating a table off all dates 750 days before 1st January 2018 therefore it would then return only Customers who did not appear within this table.
However, it appears to be including customers that DO appear in this table.
eg a customer with an order dated 22nd Dec 2016
What could be wrong here? Order Intake is linked to Calendar via Order Date