Forum Discussion

ZachUnger's avatar
ZachUnger
Helper II
2 years ago

Overdue based on multiple Columns

Morning Team 

I'm working on a report that I need to show overdue but based on criteria from multiple columns. 

 

Overdue is currently just based on Required by and today's date 

Overdue = IF('****'[Required by] < TODAY(), "Overdue")
 
But I need this to factor in if an extension has been applied Extended to
An also the Date info sent If the info has been sent it is not overdue... 

 

Hoping this makes sense = Overdue is initially based on Required by unless an extension has been applied and then Extended to becomes the new due date, but if Date info sent contains a date then it shouldn't show as overdue. 
 
Any help is appreciated. 
Cheers 
Zach 
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi ZachUnger 

     

    I'm not entirely sure I follow the logic, it'd be best to provide a table with the actual results you want.  I'm not sure if the table you've provided is what you want or what you currently have.

     

    From what you've written I understand that if Date Info Sent contains a date then it's not overdue.  Is this for all rows regardless of any other data like Extended To ?

     

    Given that all the dates in your data are in 2023, and there's no column to show when something was delivered, aren't they all overdue?  Based on today's date?

     

    Regards

     

    Phil

     

    • ZachUnger's avatar
      ZachUnger
      Helper II
      2 years ago

      Thanks Phil 

      Hoping this table helps and you are able to view it larger but the text in red is the result I'm hoping for in the overdue column. 

      Cheers 

      Zach