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
Validate your expertise in managing Jira Service Projects for Cloud. Master configuration, optimize workflows, and manage users seamlessly. Earn global 🗺️ recognition and advance your career as a trusted Jira Service management expert.
Get Certified! ✍️Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.