conditional? join 2 tables

[AUG7]

I have 2 tables loaded in power BI. 

Table 1 Observation:

Product	TimeEvent1	TimeEventMinus10Min	Date
LEGO Technic Volvo 6x6	10:45:12	10:35:12	2021-07-07
LEGO Technic Liebherr R 9800	12:13:45	12.03:45	2021-07-07
LEGO Technic RC Stunt Racer	13:30:21	13:20:21	2021-07-07
LEGO Technic Volvo 6x6	14:35:21	13:20:21	2021-07-08

Table 2 Point of Sale:

Product	TimeSold	Date
LEGO Technic Volvo 6x6	10:43:12	2021-07-07
LEGO Technic Liebherr R 9800	12:15:45	2021-07-07
LEGO Technic Volvo 6x6	13:25:21	2021-07-08

Now i want another column in Table 1 which checks if TimeSold from Table 2 'fits' between TimeEvent1 and TimeEvent2 from Table 1. The end result should look something like this:

Product	TimeEvent1	TimeEventMinus10Min	Date	TimeWindow
LEGO Technic Volvo 6x6	10:45:12	10:35:12	2021-07-07	True
LEGO Technic Liebherr R 9800	12:13:45	12.03:45	2021-07-07	False
LEGO Technic RC Stunt Racer	13:30:21	13:20:21	2021-07-07	Not sold
LEGO Technic Volvo 6x6	14:35:21	13:20:21	2021-07-08	True

I am stuck at the part where i add a new 'column' in Table 1, simply don't know which DAX i should use. 

[DataInsights · Accepted solution]

@AUG7,

Try this calculated column in Table1Observation:

TimeWindow = 
VAR vProduct = Table1Observation[Product]
VAR vDate = Table1Observation[Date]
VAR vTimeEvent1 = Table1Observation[TimeEvent1]
VAR vTimeEventMinus10Min = Table1Observation[TimeEventMinus10Min]
VAR vTimeSold =
    CALCULATE (
        MAX ( Table2POS[TimeSold] ),
        Table2POS[Product] = vProduct,
        Table2POS[Date] = vDate
    )
VAR vResult =
    SWITCH (
        TRUE (),
        ISBLANK ( vTimeSold ), "Not Sold",
        vTimeSold >= vTimeEventMinus10Min
            && vTimeSold <= vTimeEvent1, "True",
        "False"
    )
RETURN
    vResult