Show OverDue Task - Sharepoint Task List

[knishal]

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]

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]

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