Forum Discussion
AdministratorPower BI: Calculate total for each person with multiples submission
Hi all. Currently I'm having issue where I'm trying to get total points for each person. Also, I want to remove redundant names and make it as one. Refer to the example below:
What I have now:
Name | Points |
Person A | 100 |
Person A | 95 |
Person A | 70 |
Person A | 60 |
Person B | 66 |
Person B | 84 |
Person C | 90 |
What I want to get:
Name | Points |
Person A | 325 |
Person B | 150 |
Person C | 90 |
Thank you
Hi,
Refer to print below:
In the Transform TAB --> Group By --> Select Name then below name the new column Total Points. Select SUM and then the POINT column.
Result
4 Replies
- ToddChitt
Super User
Power Query, do a GROUP BY of Name, and SUM the Points.
Hi,
Refer to print below:
In the Transform TAB --> Group By --> Select Name then below name the new column Total Points. Select SUM and then the POINT column.
Result
Syndicate_AdminHi thank you for your help! I managed to remove duplicate names and get the total points for each. Thanks again 🙂
Hi,
happy that I have helped you!
✅ Consider marking the question as solved to help other understand the solution has been give.
Kudos are also accepted 😉
