Forum Discussion
Finding top sales customer
Hi
Can anyone please solve the below problem?
Identify the Star Performer for the year? based on following conditions
- Sales Orders is more than 5% of total orders
- Contribution to overall revenue is greater than 5%
- Has the highest profitability
I have these columns
| Quantity | SalesmanID | Sales | Profit | Invoice Year |
Hi Anonymous ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi3RSRsC5tw_T6Fd9?e=EhmrKf
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- mangaus1111
Solution Sage
Hi Anonymous ,
see my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi3RSRsC5tw_T6Fd9?e=EhmrKf
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.