Problems with date calculation

[jeffr6596]

I have a column for "Date Submitted" and a calculated column for "Due Date".  the Due Date column is calculated for -45 days from a third column "Implementation Date".  My calculated column is working correctly.

However, in my Dax measure I am using 

ON TIME = IF([Date Submitted] <= [Due Date], "On Time", "Late")

to indicate when an item was submitted on time or not.  I believe this should look for all submitted dates to see if they are before or on the due date.  However, I have some returns showing late when the item was submitted on the due date.

In my original data source my date submitted column has the date and time.  However, I have even gone into my querry to change the column to only show the date.   I still get an incorrect return on the on time question.

I would appreciate any help.

Thanks

[lbendlin · Accepted solution]

ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")