Forum Discussion

Klein_Hartje's avatar
Klein_Hartje
Frequent Visitor
4 years ago
Solved

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

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]      
DAX
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    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..
Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

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..