DATEDIFF: Exclude if the date is XXXX

[MickeLearnPBI]

Hi

I want to count the days between start and end, but if the EndDate is 2099-01-01 i want it to be blank or show a value.

Do you have any tips how I would do this?

Days between = DATEDIFF(
    Investigations[InvestigationStartDate],
    Investigations[InvestigationEndDate],
    DAY)

[MickeLearnPBI]

Thank you! 👍

[tamerj1 · Accepted solution]

Hi @MickeLearnPBI 

You just have drafted the answer in your question itself. 
Days between =
IF (
Investigations[InvestigationEndDate] <> DATE ( 2099, 01, 01 ),
DATEDIFF (
Investigations[InvestigationStartDate],
Investigations[InvestigationEndDate],
DAY
)
)