Number of Days Overdue

[racheljeska]

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 · Accepted solution]

@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:

https://analyticpulse.blogspot.com

Learn Powerbi

Dax functions

Powerbi Visualisation

[VahidDM · Accepted solution]

Hi @racheljeska 

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 

[AnalyticPulse · Accepted solution]

@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:

https://analyticpulse.blogspot.com

Learn Powerbi

Dax functions

Powerbi Visualisation

[racheljeska]

The Due dates are in the past

But that new column is saying 0 for Over due days 

[racheljeska]

I took out 

MAX(0,

And I think it works now. Thank you! 

[AnalyticPulse]

@racheljeska  You're welcome!