Forum Discussion
Maggi029
Helper II
Helper IIHow to combine duplicate rows and sum its values
How to combine duplicate rows and sum its values Example of my table Category Items Items Count Sell Date Fruits Apple 3 29/10/2021 Fruits Apple 2 29/10/2021 Vege...
Oh okay, In that case you can follow below steps:-
1. Click on group by option in edit query window:-
2. Then select column as below and click OK:-
3, You will see below output and then click on close and apply:-
Maggi029Helper II
Helper IIHi Samarth_18
Thanks for your response; it appears to be satisfactory; however, I must continue to use the old table in my project, as this will increase my pbix weight. My main goal is to reduce my pbix size, and to do so, I must trim down the table.
Samarth_18
Community Champion
Community ChampionOh okay, In that case you can follow below steps:-
1. Click on group by option in edit query window:-
2. Then select column as below and click OK:-
3, You will see below output and then click on close and apply:-
- Maggi029