topic Customer Retention - New Customer in DAX Commands and Tips

Customer Retention - New Customer

EarlCD — Thu, 08 Sep 2022 21:55:44 GMT

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.

Re: Customer Retention - New Customer

amitchandak — Fri, 09 Sep 2022 04:42:17 GMT

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/1377458

Customer 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/2114497

Re: Customer Retention - New Customer

EarlCD — Fri, 09 Sep 2022 05:52:16 GMT

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