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 - (Count Task ID - Status Open and Due Date within the next 30 days)

In Date - (Count Task ID - Status Open and Not Due in next 30 Days)

 

TIA! 

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.

     

3 Replies

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