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:

 

 

 

 

2 Replies

  • 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