Forum Discussion
How to add duplicate rows in PowerBI ?
Hi, My datasource looks like below where I have Duplicate rows. I would like to sum the Days column for duplicated rows. For below data the sume will be 9 for Name1 and 3 for Name2. I am not sure...
Anonymous
Drag and drop the Name field onto a Table visual and add the following measure next to it.
Total = SUM ( TableName[Days] )
FrankAT
Community Champion
Community ChampionHi Anonymous ,
you can do it like this:
Sum of Days = SUM('Table'[Days])With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Thank you!