Forum Discussion
Helper IIHow to combine duplicate rows and sum its values
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:-
Community ChampionHi Maggi029 ,
You can achive this by below two ways:-
1. Drag your column on table visual and use item count as sum
2. Or You can create a custom table with below code:-
Table 2 =
SUMMARIZE (
'Table',
'Table'[Category],
'Table'[Items],
'Table'[Sell Date],
"sum", SUM ( 'Table'[Items Count] )
)
Thanks,
Samarth
Maggi029Hi 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
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:-
- Maggi029