Forum Discussion

Lolwife1966's avatar
Lolwife1966
Frequent Visitor
5 years ago

Measure required to count overdue orders

New to Power BI so please be gentle...

 

I have a table for outstanding orders - it contains a 'date expected' field and a 'hold status' field.

An order is classed as overdue if the 'date expected' is before today and the 'hold status' is blank. 

I would like to create a measure to count the number of overdue orders but I'm not sure how to go about it, any advice would be welcome.

 

2 Replies

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hi Lolwife1966 ,

     

    Try this measure:

     

    Measure = COUNTROWS(FILTER('Table',ISBLANK([Hold Status]) && [Date expected]<TODAY()))

     

    Mark this as a solution, if I answered your question.

    Thanks 

    • Lolwife1966's avatar
      Lolwife1966
      Frequent Visitor
      5 years ago

      Thanks for that, I couldn't get that to work.

      The following seems to do the trick:

      Measure = COUNTROWS(FILTER('Table',[Hold Status]="" && 'Table'[Date expected]<TODAY()))