Forum Discussion

knishal's avatar
knishal
Regular Visitor
3 years ago
Solved

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:

 

 

Any help will be appreciated

 

 

 

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    3 years ago

    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.

4 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    3 years ago

    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's avatar
      knishal
      Regular Visitor
      3 years ago

      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's avatar
        knishal
        Regular Visitor
        3 years ago

        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?