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

[Dan492813]

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 Date	Completed Date
02/06/2020 17:00:00	02/06/2020 16:45:00
02/06/2020 17:00:00	02/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.

[amitchandak]

@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))

[Dan492813]

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

[harshnathani · Accepted solution]

HI @Dan492813 ,

You can do this is Power Query too

Make sure your Data Type is Date/Time.

Create a Custom Column.

You can also create a Custom Column

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

Regards,

Harsh Nathani

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

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