Forum Discussion
Customer Lost date [Modification of code]
Hi, I'm trying to calculate our "Customer Lost" date, defined as when a customer hasn't hade a purchase in ( last sales date + [LostDaysLimit] ) - 180 days in our case. i.e. if a customer later ...
Basically I know that if I use the the listed measure and filter it by date and customer, I will get a count of 1 on the date the customer was lost.
But instead of 1, i want the formula to return the Lost Date and then only do it once for each customer, which has to be the first Lost Date thinking I could subtract the Lost date and then select the first by using some version of minimum to get my desired result.