Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count Tasks Overdue, Approaching & In Date

Hello,   Could someone help me on the below please? I'm looking for a dax measure to count 3x separate items.   Overdue (Count Task ID - Status Open and Due Date past todays date) Approaching - ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Here I create a sample to have a test.

    Measure:

    Count Overdue = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]<TODAY()))
    Count Approaching = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]<=TODAY()+30 && 'Table'[Due Date]>=TODAY()))
    Count In Date = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]>TODAY()+30))

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Count Tasks Overdue, Approaching & In Date.pbix40 KB
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Narayana_Swamy,

 

Thanks for the fast reply! I'm looking for 3x separate measures please.

 

Thanks, 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Here I create a sample to have a test.

Measure:

Count Overdue = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]<TODAY()))
Count Approaching = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]<=TODAY()+30 && 'Table'[Due Date]>=TODAY()))
Count In Date = CALCULATE(COUNT('Table'[Task ID]),FILTER('Table','Table'[Status] = "Open" && 'Table'[Due Date]>TODAY()+30))

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Count Tasks Overdue, Approaching & In Date.pbix40 KB