Adjusting my DAX so if the two dates are the same it counts as 1 and not 0

[lynnzrae]

Hello.  I have the folloiwng DAX.

IF(

                ISBLANK(TFOIATab[Response Complete]),

                DATEDIFF(TFOIATab[Request Received], TODAY(), DAY),

                DATEDIFF(TFOIATab[Request Received], TFOIATab[Response Complete], DAY)

)

Right now if the date received and response complete are the same day, it counts as 0.  I would like for it to count as 1.  Can someone please advise what to add to the DAX to provide this change?  Thanks.

[techies · Accepted solution]

Hi @lynnzrae please check this 

IF(
ISBLANK(TFOIATab[Response Complete]),
DATEDIFF(TFOIATab[Request Received], TODAY(), DAY),
MAX(1, DATEDIFF(TFOIATab[Request Received], TFOIATab[Response Complete], DAY))
)