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.
Need to sum up values of the largest amount based on badge number and based on selected year. Below is the sample table for easy reference. I appreciate your help
Bold data (the largest of the amount for each badge number) to be added.
BadgeNo | Amount | Year |
1 | 2000 | 2018 |
1 | 3000 | 2018 |
1 | 1000 | 2019 |
1 | 5000 | 2018 |
2 | 6000 | 2018 |
2 | 8000 | 2018 |
2 | 2000 | 2019 |
2 | 5000 | 2018 |
3 | 2000 | 2018 |
4 | 5000 | 2018 |
4 | 6000 | 2018 |
5 | 5000 | 2018 |
Total for Year 2018 (based on the largest amount per badge number | 26000 |
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |