Customer Retention - New Customer

[EarlCD]

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.

[amitchandak]

@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/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retentio...

[EarlCD]

Hi @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