Forum Discussion

knishal's avatar
knishal
Regular Visitor
3 years ago

Show OverDue Task - Sharepoint Task List

Hi I am using a sharepoint task list to visualize data. I would like to create two additional column to view overdue task and completed task. I got the following error:        
knishal's avatar
knishal
Regular Visitor
3 years ago

I was able to add this fucntion that show overdue task and upcoming task. Can I modify this to show only overdue task?

 

OverDue = DATEDIFF(TODAY(), Tasks[DueDate], DAY)
  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    3 years ago

    Hi, knishal 

    The error message in the screenshot can not be recognized. Can you post the error message here?

    "First startdate" may mean that the startdate column is of type "text" instead of "Date", please double check the data types of the "Startdate" and "Duedate" columns.

     

    You can also try measure

    OverDue = IF(MAX('Table'[DueDate]<TODAY(),1,0))

    or Calculated column

    OverDue = IF('Table'[DueDate]<TODAY(),1,0)

    and apply it to visual filter pane.

     

    Best Regards,
    Community Support Team _ Eason