How to add duplicate rows in PowerBI ?

[new0220]

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!

[FrankAT]

Hi @new0220 ,

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)

[new0220]

Thank you!

[Fowmy · Accepted solution]

@new0220 

Drag and drop the Name field onto a Table visual and add the following measure next to it.

Total  =  SUM ( TableName[Days] )

[new0220]

Thank you. It worked