Forum Discussion
Customer Retention - New Customer
Hi,
I just need some help with mine and hope someone might help me out. So for the New Customers what I'm trying to get is the 1st sale date that is not 0 sales (in my case >= 0.5 sales) so I used the Dynamic Absolute pattern from Dax pattern and just add a filter
But using this measure it still gets the min sale date with 0 value sales I tried multiple workaround but I'm getting stock in this. Any leads much appreciated.
2 Replies
- amitchandak
Super User
EarlCD ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.I have discussed a few way for this
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://www.youtube.com/watch?v=W4EF1f_k6iY
Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497Hi amitchandak ,
My expected output is the one in the screenshot below.
I also uploaded a pbix file here and recreated the scenario I'm encountering.
https://drive.google.com/drive/folders/1GMo32CyM5diLJky6SmY8Hk6h2l_eNeEC?usp=sharing
