relate events in 1 table to lines in another table

[chris43]

I have a table with rows for individual events occuring on pieces of equipment in a factory. I also have another table in the same report that has shiftly data for each piece of equipment. I want to make a column in the original table or in another table that finds a piece of data in the second table at the time the event occurred and then another column that finds the same data in the second table 36 hours later. 

What would be the best way to achieve this?

[amitchandak]

@chris43 , You can write down a cross table new column

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Example

new column in Table1

Minx(filter(Table1, Table1[event] =table2[event] && Table2[Time]> Table1[Time]), Table2[Time])