cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Power 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 

1 ACCEPTED SOLUTION
AKNiang
Frequent Visitor

Hi,

 

Refer to print below:

 

AKNiang_0-1667407020680.png

 

In the Transform TAB --> Group By --> Select Name then below name the new column Total Points. Select SUM and then the POINT column.

 

Result

 

AKNiang_1-1667407050111.png

 

View solution in original post

4 REPLIES 4
AKNiang
Frequent Visitor

Hi,

 

Refer to print below:

 

AKNiang_0-1667407020680.png

 

In the Transform TAB --> Group By --> Select Name then below name the new column Total Points. Select SUM and then the POINT column.

 

Result

 

AKNiang_1-1667407050111.png

 

Hi 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 😉

ToddChitt
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors