I'm looking for a way to populate Overdue column when the End Date > Now()

[Anonymous]

Essentially I want something that will populate the overdue column with the word's "Overdue" if the End Date exceeds Now().  I've tried several IF statements and none of them seem to work, or they only calculate based on MM/DD and not the year.

The End date Column is formated as such:

And the Overdue Column is formatted this way:

If possible I would also like it to use the %Done Column as a 100% completion implies that nothing is overdue.

Thanks for any help you all can provide!

[harshnathani]

HI @Anonymous ,

Use Today () instead of NOW()

Overdue = IF ( 'Table'[End Date] > TODAY(), "Overdue" )

Incase you want to use NOW()

Column = if ('Table'[End Date] > (DATE(year(now()),month(now()),day(now()))) ,"Overdue")

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

It's listing things that are overdue, when they're not.

[harshnathani]

Hi @Anonymous ,

Cannot find any such issues in the screenshot you shared.

Can you mark which or highlight which row is causing an issue.

The one marked in Red, 30th Aug is greater then TODAY().

Cheers,

Harsh Nathani

[Anonymous]

The End Dates are all later this year (so they're not past due yet) OR they're early next year. (2021)

[harshnathani · Accepted solution]

Hi @Anonymous ,

Your End Date is in the MM/DD/YYYY  format.

Change the sign

Overdue = IF ( 'Table'[End Date] < TODAY(), "Overdue" )

What about 

09/01/2020.  Hope you are reading it as 1st September,2020. This will also not be overdue then.

Regards,

Harsh Nathani 

[parry2k]

@Anonymous try this

Overdue = IF ( Table[End Date] > TODAY(), "Overdue" )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡