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
Dan492813
Helper II
Helper II

IF date & time in column is greater than date and time in another column

Hey All

 

I am trying to find if someone has breached a SLA with customer action. 

 

I have a due date and time column and a completed date and time column 

Due DateCompleted Date
02/06/2020 17:00:0002/06/2020 16:45:00
02/06/2020 17:00:0002/06/2020 17:45:00

 

I want it to be conditional to find which rows have have a > Completed Date than Due Date.

It would also be good to be able to count and filter this. 

 

I can get it working for the date alone but not a date/time field. 

Would a new column be better? 

 

Any help would be appreciated. 

 

Thanks, Daniel.

1 ACCEPTED SOLUTION

HI @Dan492813 ,

 

 

You can do this is Power Query too

 

Make sure your Data Type is Date/Time.

 

Create a Custom Column.

 

1.jpg

 

 

You can also create a Custom Column

Column = if ('Table'[Due Date] < 'Table'[Completed Date] , "true","false")

 

1.jpg

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Dan492813 , Not sure I am clear

 

You can use this both measure or column

 

Table[Completed Date].date >Table[Due Date].date

 

measure = calculate(countrows(Table), filter(Table,Table[Completed Date].date >Table[Due Date].date))

Sorry I wasn't clear..

 

IF Due Date is < Completed date then 'true' else 'false'. It wont take into account the time only the date

HI @Dan492813 ,

 

 

You can do this is Power Query too

 

Make sure your Data Type is Date/Time.

 

Create a Custom Column.

 

1.jpg

 

 

You can also create a Custom Column

Column = if ('Table'[Due Date] < 'Table'[Completed Date] , "true","false")

 

1.jpg

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

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.