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 ))
amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Need the correct table name, also need to know how openTaks works

 

Tasks Approaching = CALCULATE([OpenTasks] , Filter(Date, Date[DueMonth] >= TODAY() + 30))
 
if open task measure is snapshot measure, refer
Average of Rolling, Average of Snapshots: https://youtu.be/_pZRdLAJxxA
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello amitchandak  thank you for the reply, I get the following error -