Forum Discussion
Replace duplicated values with average in Power Query
Hi, in this scenario, i have 3 duplicates, and among all these 3 duplicates, all has the same values except for the score, where each duplicate have a different score. is there any way in power query, where i can find the average of these 3 scores, then followed by removing the duplicated rows.
attached an image for reference.
3 Replies
- PijushRoy
Community Champion
Hi amethyst_tang_2
Please use Group by with the Overview column
and Avg for the other 4 numeric column
ExampleIf your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricksHi, do you have any idea, after getting the average value, how do i put the value back to the original data and remove the other duplicated rows then?
Hi PijushRoy, have tried the groupby method. However, it seems that I can only combine the 3 values together.
however, i hope that i am able to remove those duplicated values then replace with the average, all doen via Power Query. Do you think there are any way to solve this?
