Creating calculated formula for Target Start date<now()

Code needed to create calculated formula for Target Start<Now()

Hello @Dipanjana
Welcome to eazyBI community!

In eazyBI we have various functions to compare date members, filter date members, find specific dates etc. You can learn about that here MDX function reference

In you case, I recommend using Datecompare function.
Function returns -1 if first date is less than second date, 1 if first date is greater than second date, and 0 if dates are equal.

For example, your formula might look as follows:

DateCompare([Measures].[Issue Target Start],Now()) < 0

It will return “True” when Issue Target Start is less than Today.

Best wishes,

Elita from