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
TAGS
atlassian, jira cloud certification, managing jira projects, jira project administration, jira cloud exam, atlassian certification, agile project management, jira workflows, jira permissions, jira training, jira cloud skills, atlassian learning

Become a Certified Jira Service Project Expert 🦸🏻‍♂️

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! ✍️
AUG Leaders

Atlassian Community Events