Merging between two columns depending in three different conditions

ZeinabGad can you share sample data to show how your tables are and if they have relation?

Can you please share the Sample data and the desired output ?

Thanks,

Amit Dhiman

---

ZeinabGad wrote:

Hello,

 

I'm facing a problem with the data I have 

 

In one table, I have a line, the shift and day, these three identify the row (Loading time) I need the Power Bi to fetch. 

In the other table (Machine breakdown) I have the same date, line and shift but they are repeated for different machines

 

I need to calculate the percentage of contribution of that machine in breakdowns from the time of the shift. 

 

Any Idea how?

---

Can you please share the sample data and the desired output ?