How to generate result by comparing 2 column in different table and involve "and" function

[Anonymous]

Hi everyone. Hope you doing well

Have face one difficulties in Power BI that would like to require your kind assisntant. 

In PO table, i wanted to create a column that consist a logic of = if on time delivery ( in PO table) is equal to "On time" and Full/Partial Delivery (in GRN table) is equal to " Full delivery" , then generate "yes", else 'No")

The result expecting is something stated below. as only PO number 101 to 105 met the requirement of having "On time" in On time Delivery column and "Full Delivery" in Full/Partial Column. so it show a yes, and other show a no

[Fowmy · Accepted solution]

@Anonymous 

Add the following Column in the PO Table

Status =
IF (
    'PO Table'[On Time Delivery] = "On Time"
        && LOOKUPVALUE (
            'GRN Table'[Full/Partial Delivery],
            'GRN Table'[PO Number], 'PO Table'[PO Numbe]
        ) = "Full delivery",
    "Yes",
    "No"
)

[Anonymous]

Hi !!! thank you so much for your help !!! really appreciate that !!