Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear,
I'm having issues to create some reports, I should need to report Salesmen yearly interest rate average target fixed by the business [2,5%] but I don't know how should I even calculate it, for instance: salesman can have, or should have, multiple sales in a year and each sale has different contract's length and/or interest rate as following:
Salesman 1
* Customer A: Contract for 4 years - rate of 4,52%
* Customer B: Contract for 2 years - rate of 10,23%
* Customer C: Contract for 6 years - rate of 2,10%
Salesman 2
* Customer A: Contract for 6 years - rate of 4,52%
* Customer B: Contract for 8 years - rate of 10,23%
* Customer C: Contract for 10 years - rate of 2,10%
If I had to calculate the average interest rate of these 2 salesmen I would say both salesmen have the same average interest rate 5,616% but this is not correct because I'm not taking in consideration the length of contracts, I really don't know how to get around this.
Could please someone help me out?
Solved! Go to Solution.
How about a weighted average?
Salesman 1: (4 * 4,52% + 2 * 10,23% + 6 * 2,10%) / (4 + 2 + 6) = 4,262%
Salesman 2: (6 * 4,52% + 8 * 10,23% + 10 * 2,10%) / (6 + 8 + 10) = 5,415%
How about a weighted average?
Salesman 1: (4 * 4,52% + 2 * 10,23% + 6 * 2,10%) / (4 + 2 + 6) = 4,262%
Salesman 2: (6 * 4,52% + 8 * 10,23% + 10 * 2,10%) / (6 + 8 + 10) = 5,415%
Hi Marcel,
Like that one, I will try this for sure.
Thx
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |