How to compare two date columns in the same table using the operator Greater

Klein_Hartje — Wed, 25 May 2022 23:43:35 GMT

Please I want to calculate this metric and it returns TRUE or FALSE:

Late Deliveries Flag = [Order Delivered Date to Customer] > [Order Estimated Delivery Date]

Re: How to compare two date columns in the same table using the operator Greater

Whitewater100 — Thu, 26 May 2022 00:08:31 GMT

Hi:

If you do it as calculated columnin the same table where this info is:

Flag = IF(TableName[Order Delivered Date to Customer] < TableName[Order Estimated Delivery Date] ,"TRUE", "False")

as a measure:

Flag T/F =

var orderdelivered = SELECTEDVALUE(TableName[Order Delivered Date to Customer)

var estdeldate = SELECTEDVALUE(TableName[Order Estimated Delivery Date])

return

IF(orderdelivered > estdeldate,"TRUE", "False")

I hope this works for you. Thanks..