How to compare date in different table

[Anonymous]

Hi Guys, may i know how can i create a column in PO table which have a logic of, if PO date inside PO table is larger than the GRN date in GRN table, than "On time delivery" else "Delayed Delivery". Thank you 

PO table

GRN Table

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You could create a column as below:-

Column =
VAR GRN_date =
    LOOKUPVALUE (
        'GRN Table'[GRN date],
        'GRN Table'[PO Number], 'PO Table'[PO Number]
    )
RETURN
    IF ( 'PO Table'[PO Delivery Date] > GRN_date, "On Time Delivery", "Delay" )

BR,

Samarth

[Anonymous]

Hi !!! Thank you so much for helping me out, really appreciate that !!!!