Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
new0220
New Member

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!

Capture.JPG

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@new0220 

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

Total  =  SUM ( TableName[Days] )


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
FrankAT
Community Champion
Community Champion

Hi @new0220 ,

you can do it like this:

 

03-06-_2021_16-45-52.png

 

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!

Fowmy
Super User
Super User

@new0220 

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

Total  =  SUM ( TableName[Days] )


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thank you. It worked

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.