Show overdue task

[knishal]

I currently have this formula which shows the amout of days its due by: 

OverDueTask = DATEDIFF(TODAY(), Tasks[DueDate], DAY )

How can I modify it to show only OVERDUE Task and the day count?

[knishal]

@PabloDeheza works. Thank you

[PabloDeheza · Accepted solution]

Hi there!
You can use a IF statement, so:

VAR _Days =

DATEDIFF(TODAY(), Tasks[DueDate], DAY ) 

RETURN

IF(

_Days >= 0,

BLANK(),

_Days

)

Let me know if that helps!