I’m a relative beginner with DAX, but I’m trying to develop a Dashboard quickly.
I watched your Scenario Method Workshops going through the New Customer and Lost Customer analysis. However, the Lost Customer DAX function wasn’t exactly what I was looking for…
I wrote this DAX function for Lost Customers and it seems to work - well sort of.
The problem is that all the data points are time-shifted by 1 year!
So when I verify the customer data for a lost customer on Jan-2018, I find the customer was lost on Jan-2017.
I don’t really understand the operation of the Filter function on the Date table.
Could you point out some videos that go through the operation?
LostCustomers = VAR CurrentCustomers = CALCULATETABLE(VALUES(CustomerInvoices8[Customer]), FILTER(All(Date4), Date4[Date] > MAX (Date4[Date]) -365 && Date4[Date] < MAX (Date4[Date]))) VAR PriorCustomers = CALCULATETABLE(VALUES(CustomerInvoices8[Customer]), FILTER(All(Date4), Date4[Date] > MIN (Date4[Date]) - 365 && Date4[Date] < MIN(Date4[Date])-90)) RETURN COUNTROWS(EXCEPT(PriorCustomers, CurrentCustomers))