Easy BI || Error while checking is empty on date field

theja.85 · September 8, 2023, 10:28am

Hello,

Can anyone help me with the below error? I am comparing two dates, and when the second date is null or empty, I mark it with today’s data.

Elita.Kalane · September 8, 2023, 12:40pm

I recommend trying the formula below and using function CoalesceEmpty instead of IsEmpty:

DateDiffDays(
  [Measures].[Issue Original Planned Deployement],
  CoalesceEmpty([Measures].[Issue Actual Deployment Date],"today")
)

Best wishes,

theja.85 · September 11, 2023, 5:48am

Thanks Elita. Its working.