topic Re: How to compare date in different table in DAX Commands and Tips

How to compare date in different table

Anonymous — Sun, 29 May 2022 04:49:23 GMT

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

Re: How to compare date in different table

Samarth_18 — Sun, 29 May 2022 05:29:18 GMT

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

Re: How to compare date in different table

Anonymous — Sun, 29 May 2022 05:34:40 GMT

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