Forum Discussion
Solved
Problems with date calculation
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
ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")
1 Reply
ON TIME = IF(DATEVALUE([Date Submitted]) <= [Due Date], "On Time", "Late")