Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Klein_Hartje
Frequent Visitor

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]
 
 
 
1 ACCEPTED SOLUTION
Whitewater100
Solution Sage
Solution Sage

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

View solution in original post

1 REPLY 1
Whitewater100
Solution Sage
Solution Sage

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors