Power BI: Calculate total for each person with multiples submission

[Syndicate_Admin]

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 

[AKNiang · Accepted solution]

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_Admin]

Hi thank you for your help! I managed to remove duplicate names and get the total points for each. Thanks again 🙂

[AKNiang]

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 😉

[ToddChitt]

 Power Query, do a GROUP BY of Name, and SUM the Points.