Merging between two columns depending in three different conditions

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?

---