Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

EazyBI - User Defined Measure for Dates

Kinsey February 5, 2020

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"?

1 answer

0 votes
Fabian Lim
Community Champion
October 30, 2021

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

Suggest an answer

Log in or Sign up to answer