I am attempting to complete a CASE statement in EazyBI to enter 0 when there is a certain date field containing a date of Jan 01 2000.
How can I take a measure (Date Introduced to Production - which is a datetime) and compare it to a string like "Jan 01 2000"?
Hi Kinsey,
You can use the DateCompare function which is explained here: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.