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.
My objective is to present a report which shows each agent’s name, the total sales amount for that agent for the month and the commission earned based on the commission policy.
Here is more context for you:
Please find data set here: https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
https://docs.google.com/spreadsheet...ouid=104129043494164133703&rtpof=true&sd=true
And
pbix: https://drive.google.com/file/d/1dGgyQ185t5uJjGZgNPbNyw71jVWvkHLu/view?usp=sharing
Hi @Yrstruly2021 ,
How to use the fowllowing three datasets? Why don't you add them into the pbix file? Could you please provide a similpe sample about how to calculating? Providing so many words caused my whole person to be confused.
How to Get Your Question Answered Quickly
It is best to provide the output you want in image form.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |