Overdue based on multiple Columns

[ZachUnger]

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 

[PhilipTreacy]

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]

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