Extract and Visualize unique customers (customer ID) gained on monthly basis

[dawoodrana]

Hi Everyone,
I want to get the new customers based on customerIDs on monthly basis.

Followings points should be considered;
Point 1: If a specific customerID appears in 1st month e.g Apri 2021 and again it appears in next months like May and August. The extraction should only consider that customerID when it first appears and ignore its appearence for rest of the months. Same goes for All customerIDs

Point 2: I want to know how many new customers I have gained on monthly basis omiting the customers that already appears last months. Also, consider the unique customerID not the repeating one as I mentioned in "point 1". 

Regards,
Dawood

[v-janeyg-msft]

Hi, @dawoodrana 

Can you share some dummy sample data and your desired result? So we can help you soon.

Reference:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Community Support Team _ Janey

[amitchandak]

@dawoodrana , refer if this can help

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...

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