Forum Discussion
DAX sum filter dates.
Hi, I'm trying to get rentention percentage of each customer ID, but there are 3 conditions that identify the customer is retained or not. (if any of these are appliable, then the customer is retaine...
Let me revise what I posted. We consider
Case 1 = the customer is retained if the customer only bought our company's unit in last 2 years, the customer is retained
Case 2 = if the customer did not purchased any products (which means did not buy any other competing companies' product) for 2 years but bought our company's product on 3rd year, then the customer is retained.
Case 3 = if the customer did not purchased any other brands' product but bought our product for the last 3 years straight, then the customer is retained.
Case 1 seems to have a strange meaning with respect to retention?
I think we use case 1 for calculating loyalty % of customers later.