Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

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: ...
  • AKNiang's avatar
    AKNiang
    3 years ago

    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

     

     

AKNiang's avatar
AKNiang
Frequent Visitor
3 years ago

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's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

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

    • AKNiang's avatar
      AKNiang
      Frequent Visitor
      3 years ago

      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 😉