Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bilalkhokar73
Helper IV
Helper IV

Newcustomer sales irrespective filters

Hi,

I need a help that every month New csutomer used to add and my dim customer table has date column that on which date this customer was added
Which customer belongs to which Salesman is a seprate raw data for that which is [sr wise route data]
I want to make count of total cusotmer added by Salesman wise in current month and sales of new customer added in current month irrsepective of any filters

This is the file, I tried to add a column in sr wise route table 
LInk to download power bi file - https://we.tl/t-Sq3xU1yt8l
@amitchandak @DataVitalizer 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@bilalkhokar73 , what is the definition of new?

 

refer if these can help

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

 

 

 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...

View solution in original post

2 REPLIES 2
bilalkhokar73
Helper IV
Helper IV

@amitchandak  actually I don't need customer retention, in every month new customer used to add in my customer portfolia for which my DIm customer table has entry , i just need new customer added in current month And there sales

amitchandak
Super User
Super User

@bilalkhokar73 , what is the definition of new?

 

refer if these can help

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

 

 

 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...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors