topic Re: Number of Days Overdue in DAX Commands and Tips

Number of Days Overdue

racheljeska — Wed, 15 May 2024 18:39:15 GMT

Column [Status] has either Completed, Overdue, or Coming Due

I want to create a new column named Days Overdue that only uses Overdue from the Status Column

If it is Overdue, then count the days between TODAY and the [Due Date]

If Completed or Coming Due, leave it blank.

Thank you!

AnalyticPulse — Wed, 15 May 2024 18:44:33 GMT

racheljeska
add below calculated column to achieve this:

Days_Overdue = IF( [Status] = "Overdue", MAX(0, DATEDIFF(TODAY(), [Due Date], DAY)), BLANK() )

Learn Power BI free:

racheljeska — Wed, 15 May 2024 18:54:58 GMT

The Due dates are in the past

But that new column is saying 0 for Over due days

racheljeska — Wed, 15 May 2024 18:56:45 GMT

I took out

MAX(0,

And I think it works now. Thank you!

AnalyticPulse — Wed, 15 May 2024 19:00:42 GMT

racheljeska You're welcome!

VahidDM — Wed, 15 May 2024 21:18:29 GMT

Try this:

DaysOverdue = IF ( [Status] = "Overdue", DATEDIFF ( TODAY (), [Due Date], DAY ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube