cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!