Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,257,453
Community Members
 
Community Events
164
Community Groups

EazyBI calculated member problem

Hi, 

I´m triying to define a calculated member that when a date measure is greater than current day, it shows the current day:

CASE WHEN DateCompare([Measures].[Issue Target end],Now())=-1
THEN
[Measures].[Issue Target end]
ELSE NOW()
END

But it gives me this error:

Formula is not valid:
No function matches signature 'CASE WHEN <Logical Expression> THEN <Expression> ... END'

How can i get this?

2 answers

In my case (no pun intended) I was evaluating a set of calculated members that were booleans.  My first attempt looked like this:

CASE
WHEN [Members].[Custom Boolean Field 1] THEN 'Case 1'
WHEN [Members].[Custom Boolean Field 2] THEN 'Case 2'
ELSE 'Other'
END

And I was getting the same formula error.  I needed to adjust it to:

CASE
WHEN [Members].[Custom Boolean Field 1].Value THEN 'Case 1'
WHEN [Members].[Custom Boolean Field 2].Value THEN 'Case 2'
ELSE 'Other'
END

Hi,

You are on the righ track, however, the "Case when" structure is picky for formats.

Try using DateParse to force the right format for the Issue target end property.

 

CASE WHEN DateCompare([Measures].[Issue Target end],Now())=-1
THEN
DateParse([Measures].[Issue Target end])
ELSE NOW()
END

 

And don't forget to save your calculated measure in the right format (Month Day Year)

Martins / eazyBI support

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

1,497 views 11 22
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you