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
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 Code | Customer Name | Active & InActive |
TRD00755 | XYZ 01 | Active |
TRD00791 | XYZ 02 | Active |
TRD01349 | XYZ 03 | Active |
TRD00564 | XYZ 04 | Active |
TRD00690 | XYZ 05 | InActive |
TRD01379 | XYZ 06 | Active |
TRD01167 | XYZ 07 | Active |
2nd table
Sales invocie header
Invoice No | Customer Code | Invoice Date |
IN000001 | TRD00755 | 04/01/2015 |
IN000002 | TRD00791 | 04/01/2015 |
IN000003 | TRD01349 | 04/01/2015 |
IN000004 | TRD00564 | 04/01/2015 |
IN000005 | TRD00690 | 04/01/2015 |
IN000006 | TRD01379 | 04/01/2015 |
IN000007 | TRD01167 | 04/01/2015 |
IN000008 | TRD00942 | 04/01/2015 |
IN000009 | TRD00777 | 04/01/2015 |
IN000010 | TRD01238 | 04/01/2015 |
IN000011 | TRD00265 | 04/01/2015 |
IN000012 | TRD00537 | 04/01/2015 |
IN000013 | TRD01358 | 04/01/2015 |
IN000014 | TRD00705 | 04/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
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
@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
@Anonymous
Try this:
https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/m-p/168297#M13
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
157 | |
137 | |
132 | |
81 | |
61 |