Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count Tasks Next 30 Days

Hello,   I'm trying to count the tasks which are due in the next 30 days (from today). Is the below the correct measure?   Tasks Approaching = CALCULATE([OpenTasks] , (Date[c.DueMonth] >= TODAY(...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    Tasks Approaching = 
VAR _StartDate =TODAY()
VAR _EndDate = _StartDate +30
RETURN

CALCULATE([OpenTasks] , DATESBETWEEN(Date[c.DueMonth], _StartDate,_EndDate ))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you so much Ahmedx this has worked!

 

How could I count the open tasks which are "in date" also? So, not yet due? 

Ahmedx's avatar
Ahmedx
Super User
3 years ago

did not understand, explain in more detail what you want and by what principle the task is considered open?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry Ahmedx , I wish to count the open tasks which are not yet due (Due Date is over 30 days in front)

     

    So ideally I'm looking for 3x measures in total, In Date, Approaching and Overdue.  

     

    Would the below be correct for In Date?

    In Date = CALCULATE([m.OpenTasks], (modHelpdeskWithHistoryV3[c.DueMonth] <= TODAY()))
    • Ahmedx's avatar
      Ahmedx
      Super User
      3 years ago

      this will give you tasks that are overdue