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 how to achieve this? Any help is appreciated! Thanks in advance for your time!
Anonymous
Drag and drop the Name field onto a Table visual and add the following measure next to it.
Total = SUM ( TableName[Days] )
4 Replies
- Fowmy
Super User
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
Hi 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)
