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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
christianNavarr
New Member

How to combine these tables?

Hi, every body!

I need to combine these two tables, One is called "Horometros" and another "Mantenimiento". In the table Horometros i have a compilation of the work hours of the machines, in the Mantenimeinto table i have all the failures presented in the maquinary. I have to combinate these tables to calculate the KPI´s. My problem is, when i combine the tables, the values of working hours are duplicated in response to the mantenimiento extra rows and the amount of hours is too hi than the real, i nedd use the columns date, equipment and shift work to do a condition. Can anyone helpme with this please.

 

christianNavarr_0-1696638890079.png

 

christianNavarr_1-1696639274373.png

 

 

1 ACCEPTED SOLUTION
rubayatyasmin
Super User
Super User

@christianNavarr hi,

 

Make sure the columns you are using to merge are unique. If any of your columns have duplicate values it will create duplicates. Check these three column by using group by. You will know if any of the column has duplicate values. 

 

 

Did I help? If yes, hit 👍 and accept my solution as answer. 

 

 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


View solution in original post

1 REPLY 1
rubayatyasmin
Super User
Super User

@christianNavarr hi,

 

Make sure the columns you are using to merge are unique. If any of your columns have duplicate values it will create duplicates. Check these three column by using group by. You will know if any of the column has duplicate values. 

 

 

Did I help? If yes, hit 👍 and accept my solution as answer. 

 

 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors