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


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.

Hi @theja.85

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

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

Best wishes,

Elita from support@eazybi.com

Thanks Elita. Its working.

1 Like