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.
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
Solved! Go to 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
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
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 😉
Power Query, do a GROUP BY of Name, and SUM the Points.
Proud to be a Super User! | |
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.