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.

     

Narayana_Swamy's avatar
Narayana_Swamy
New Member
3 years ago

Hi Anonymous ,

 

A little bit of additional context would help. I am looking for:
1. Do you need 3 seperate outputs (matrix with 3 values as outputs) or everything in 1 (based on selected taskID)

  • 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.