Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to compare date in different table

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". ...
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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