Forum Discussion
Lost Customers
Hi Team, 1.We have tried to get lost customers data (count and User details) over any date range it means last some months/years/days. Eg: We have data from 01-jan-2020 and we have selected d...
hi Anonymous,
all you need is max(transactiondate) per customer. You should filter this table with transactions <= max(selecteddate) first, if you really want a timespan.
Then you can create your measures:
1. If max(transactiondate) <= min(selecteddate) then 1 else 0
2. If max(transactiondate) between dateadd(month,-1,min(selecteddate)) and min(Selecteddate) then 1 else 0
If you could provide an example, I would create a quick tutorial.
Liked this post? Please subscribe: https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ