Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help needed for 'Overdue Items' in Power BI

I am working on creating a report that will show any items that are due past a certain due date. I am hoping to create either a measure or a new column with this info. The columns I need to use to g...
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous -

     

    Yes, we can add TODAY() in there. Try this out

     

    IsOverdue = 
var __Status = [Status]
var __ActionDt = [Action Due Date]
var __ClosedDt = [Closed Date]
return
IF ( __Status = "Complete", 0,  //Filter out "Complete"
    IF ( __ActionDt >= TODAY(), 0,  //Filter out future due dates
      IF ( __ActionDt > __ClosedDt ||  //Closed item from the past was overdue when completed
               ISBLANK( __ClosedDt ),  //Open item has due date in the past
          1, 0 )
    )
)

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous -

 

Yes, we can add TODAY() in there. Try this out

 

IsOverdue = 
var __Status = [Status]
var __ActionDt = [Action Due Date]
var __ClosedDt = [Closed Date]
return
IF ( __Status = "Complete", 0,  //Filter out "Complete"
    IF ( __ActionDt >= TODAY(), 0,  //Filter out future due dates
      IF ( __ActionDt > __ClosedDt ||  //Closed item from the past was overdue when completed
               ISBLANK( __ClosedDt ),  //Open item has due date in the past
          1, 0 )
    )
)

 

Hope this helps

David

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you so much! This worked perfectly