The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
@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.
Proud to be a 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.
Proud to be a Super User!