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:

Any help will be appreciated

[v-chenwuz-msft]

Hi @knishal ,

Please try change the type of [DueDate] to Date to fix the error meassage.

Or try this code to create a measure and put it in this visualization

if(max('table'[Duedate]) >today ,1,0)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[knishal]

@v-chenwuz-msft  that works but shows "1" how can I display the amount of days it will be due in?

This is what I use: 

UpcomingTask = IF(MAX(Tasks[DueDate]) >TODAY(),1,0)

[knishal]

@v-chenwuz-msft I currently have this formula which shows the amout of days its due by:

OverDueTask = DATEDIFF(TODAY(), Tasks[DueDate], DAY )

How can I modify it to show only OVERDUE Task and the day count?

[v-chenwuz-msft · Accepted solution]

Hi @knishal ,

Maybe this formual

=

VAR _D=DATEDIFF(TODAY(), Tasks[DueDate], DAY )

RETURN

IF(_D<1,"OVERDUE Task",_D)

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.