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
Icon for Super User rankSuper User
3 years ago

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