Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I got one more problem (this is endless!?)
I would like to calculate the new business. This would be the customers, for each month, who subscribe something (with invoice).
I got one table with my customers (with a calculated measure), one table with the related salers (those two tables are linked) and tables with invoices (which is linked with the customers)
I have something like that (X is my boolean newbusiness or not/Nb is only a distinctcounter to get the number of new customers) :
1. X is not a sum -> How would I do to have 43 (instead of 1)?
2. This is not working when I choose many month -> All the customers appears with 0 or 1
3. I would have it by salers -> How would I do? Now, I actually have all the amounts, not only the new business.
Thank you for all,
Solved! Go to Solution.
@Anonymous,
You may try a similar way as shown here.
Hi @Anonymous,
You question is not very clear can you please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).
If you can share some sample data and outcome it's easier to help you, it can be a mockup of your data and not actual data itself, if the model is to complex to make a mockup you can also share it trhough private message instead.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsOk, sorry
I found out something right but that's not enough.
So,
On table with my customer :
Ref Name Saler
CRM-01 CompanyX SL-01
CRM-02 CompanyY SL-02
...
One table with my salers
Ref Name
SL-01 MisterX
SL-02 MissY
...
One table SalesOrders
Ref Date AAAA_MM Customer Amount
SO-01 01/05/2018 2018_05 CRM-01 1000€
SO-02 05/10/2018 2018_10 CRM-02 500€
...
So, I would numerate the customer (and amount) who did not have any salesorder for the 12 last past months but have an amount on the selected month.
I got a measure ont my table salers [NewBusiness]-> calculate(sum(SalesOrder[Amount]);FILTER(Customers;[NBMeasure]=1)
with [NBMeasure] (table customer)=IF(AND([CA_13mois]=0;sum(Salesorders[Amount])<>0);1;"")
and [CA_13mois] is the amount for the last past 12months.
@Anonymous,
You may try a similar way as shown here.
I try SUMMARIZE function (I think I never did it before) and it's working!
Thank you!
Thank you,
I think it's not actually the same problem.
I got 3 tables (salers, customers and orders).
Anyway, I shall think about your answer. Thanx.
I let you know.
User | Count |
---|---|
103 | |
87 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |