Forum Discussion
Solved
Getting Distinct Row WRT ID by Summing multiple category values
Hi v-yanjiang-msft I have a table with multiple rows with the same ID but different values. my requirement is to remove other duplicate rows but by adding the values from other multiple rows below...
Don't think you need to use M code, you can just the UI. Click on the ID column, choose the Transform section of the ribbon and choose Group By. You can then specify which column you want to aggregate and how you want to do it - sum, count etc.
Don't think you need to use M code, you can just the UI. Click on the ID column, choose the Transform section of the ribbon and choose Group By. You can then specify which column you want to aggregate and how you want to do it - sum, count etc.
Thank you for the quick response and for the Solution