Date format issue when comparing dates

Questions & Answers
1

I am trying to compare a date from a measure and fixed date. Following is the new measure I am trying to create:

CASE
WHEN
---- DateCompare( [Measures].[Issue closed date], 2024-10-01)>0
DateCompare( [Measures].[Issue closed date], ‘Oct 01 2024’)>0
THEN
([Measures].[Story Points closed] )
END

I tried date format (commented out) and string format as the fixed date. The commented date format compare returns nothing. The comparison with ‘Oct 01 2024’ returns ‘mmm dd yyyy’. I can’t figure out the data type for ‘[Measures].[Issue closed date]’. Format function did not help. I would appreciate if someone can suggest something I can try.

2

Hi @Mike_Blue,

You will need to change the formatting manually to Numeric → Decimal (or Integer, if it better suits your needs).

1782×982 108 KB

I hope this helps!

Best,
Marita // support@eazybi.com