Forum Discussion
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". Thank you
PO table
GRN Table
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
2 Replies
Samarth_18Community Champion
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