Count Tasks Next 30 Days

[Anonymous]

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() + 30))

Thanks, 

[Ahmedx · Accepted solution]

pls try this

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

CALCULATE([OpenTasks] , DATESBETWEEN(Date[c.DueMonth], _StartDate,_EndDate ))

[Anonymous]

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]

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

[Anonymous]

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]

this will give you tasks that are overdue

[amitchandak]

@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]

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