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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

New Customer Added

Dear All,

 

I have been asked to make reports where i have two tables of navision

 

1. Customer details

2. Sales invoice header

 

1st. customer table

 

Customer CodeCustomer NameActive & InActive
TRD00755XYZ 01Active
TRD00791XYZ 02Active
TRD01349XYZ 03Active
TRD00564XYZ 04Active
TRD00690XYZ 05InActive
TRD01379XYZ 06Active
TRD01167XYZ 07Active

 

 

 

2nd table

Sales invocie header

 

Invoice NoCustomer CodeInvoice Date
IN000001TRD0075504/01/2015
IN000002TRD0079104/01/2015
IN000003TRD0134904/01/2015
IN000004TRD0056404/01/2015
IN000005TRD0069004/01/2015
IN000006TRD0137904/01/2015
IN000007TRD0116704/01/2015
IN000008TRD0094204/01/2015
IN000009TRD0077704/01/2015
IN000010TRD0123804/01/2015
IN000011TRD0026504/01/2015
IN000012TRD0053704/01/2015
IN000013TRD0135804/01/2015
IN000014TRD0070504/01/2015

 

I have calculated how many total customers = count('customer master'[customer code])

 

Active customers = calculate(Count('customer master'[customer code]),'customer master[Active & InActive] = Active)

the same way i have calculate InActive Customers

 

but i have to calcualte How Many new customers are added and he want a year filter so he can select any year and see how many new customers are added in that perticualar based on customers' first (Posting Date/Invoice Date).. 

 

But I don't how can i calculate this thing

 

please someone help

 

Thanks

Arif

3 REPLIES 3
sturlaws
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

did either of the answers you got provide you with a solution?

 

If yes, could you please accept the most helpfull one as the answer? It will be helpfull for other users with similar questions.

 

Cheers,
Sturla

amitchandak
Super User
Super User

@Anonymous , refer if this solution can help

https://community.powerbi.com/t5/Desktop/Churn-Rate-lost-Customer/m-p/1173754#M529196

 

pbix attached with Solution

Greg_Deckler
Super User
Super User

@Anonymous 

 

Try this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/m-p/168297#M13

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.