DaysLeft/DATEDIFF to return correct days left/date difff

[dd88]

DaysLeft column uses DATEDIFF forumula

DaysLeft = DATEDIFF('Table_INPUTDATA_Ref'[Task DueDate - Copy], TODAY(),DAY)

Task DueDate, column Type is Text
Task DueDate - Date, column Type is Date

DueStatus column, has conditions and is displaying incorrectly.

I noticed DaysLeft returned values that are 'reversed' ie positive days 8914 are suppose to be negative -8914. The negative days -96 are supposed to be positive ie 96

The result is, the column DueStatusdisplays DueStatus incorrectly.

How can DaysLeft/DateDiff  return an accurate values

TIA

[dd88]

many thanks @Irwan  thats great ..   

[Irwan · Accepted solution]

Hello @dd88 

I assumed 1/09/2024 means 1 September 2024.

Looking at your DAX, start date is 1/9/2024 and end date is TODAY(), the value will be negative because end date is less than start date.

Try switching the DAX.

DaysLeft = DATEDIFF(TODAY(),'Table_INPUTDATA_Ref'[Task DueDate - Copy],DAY)

Hope this will help you.

Thank you.