Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Sorry, I did not get the answer from my previous post so reporting this again.
I have an issue showing the NBTO sale (New Business Turn Over) visual in Power BI. A customer is a new customer until 12 months since it started and after 12 months it falls in the existing customer bucket. Any invoice raised before the start date should not be calculated as NBTO and any Invoices raised after 12 months of the Invoice date should be in Existing Customer Bucker.
Invoice raised within 12 months from the start date is to be considered as NBTO.
For Example:-
Client “Better Leather” start date is 1st August’20. So this client will be NBTO from 1st September’20 until 31st August’21.
Now the matrix visual should show as:-
I have attached the PBIX file for your review. Click Here
Solved! Go to Solution.
Hi @gauravnarchal ,
You don't need to create the "ISNBTO" column. You could directly get the amount by using below formula.
Hi @gauravnarchal ,
You don't need to create the "ISNBTO" column. You could directly get the amount by using below formula.
Hi,
You can create a category measure and then use this to calculate the revenue based on customer category.
E.g. [Category] = SWITCH(TRUE(),condition1, category1,condition2,category2)
[New Customer Sales] = SUMX(Table,CALCULATE(SUM(Table[Sales]),[Category]="New Customer")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hello @ValtteriN I can create the column as you suggested, but before that, I would like to check from where is the Contract Start Date taken into consideration? A customer is a new customer until 12 months since it started (As per the start date).
For Example:-
Client “Better Leather” start date is 1st August’20 (Refer - ClientGroupMaster Table). So this client will be NBTO only from 1st September’20 until 31st August’21.
I am sorry if I missed anything and thank you for looking into this.
Hi,
My suggestion is that you create a measure which categorises customers. So then contract start would be included in e.g. condition1
Proud to be a Super User!
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |