creating a bucket of true and false

[pparmar]

Y/N = IF('SO-Shipping report'[DOW_Requested] = CONTAINS(Sheet1, Sheet1[DOW_requested],AND( 'SO-Shipping report'[Shipping method] = CONTAINS(Sheet1,Sheet1[Shipping Method]), AND('SO-Shipping report'[Days Between]<= CONTAINS(Sheet1,Sheet1[Days Expected to Ship]),TRUE(),FALSE()), Blank)))

I need to create a bucket of the order id's following in this category. 
to create a custome column in table 2, where we check for the condition " if (DOW(table 2) = DOW(table 1) && shipping method(table 2) = shipping method(table 1) && Days between <= days expected to ship, "true", "false")  "
How should I go ahead and write the DAX query here ? 
for ex: this is table 1  


Table2: both images belong to the same table. 

  

[Mahesh0016 · Accepted solution]

@pparmar  I have used lookup because I have no relationship between both tables you can use related if you have a relationship with both tables.

Test = 
IF (
    'DOW 2'[DOW_requested]
        = LOOKUPVALUE (
            'Dow 1'[DOW_requested],
            'Dow 1'[DOW_requested], 'DOW 2'[DOW_requested]
        )
        && 'DOW 2'[Shipping Method]
            = LOOKUPVALUE (
                'Dow 1'[Shipping Method],
                'Dow 1'[Shipping Method], 'DOW 2'[Shipping Method]
            )
        && 'DOW 2'[Day Between]
            <= LOOKUPVALUE (
                'Dow 1'[Days Expected to Ship],
                'Dow 1'[Days Expected to Ship], 'DOW 2'[Day Between]
            ),
    "True",
    "False"
)

 I hope this helps you! Thank You!!