Show Due Date if Resolved at (date) is Empty

Questions & Answers
1

If [Issue].CurrentHierarchyMember.get(‘Resolved at’) IS NOT NULL I want to show it in my Column other wise show [Measures].[Issue due date]. I think this easy but no luck so far.

I have tried this but it is not valid:

CASE
WHEN
IsEmpty([Issue].CurrentHierarchyMember.Get(‘Resolved at’))
THEN [Measures].[Issue due date]
ELSE
[Issue].CurrentHierarchyMember.Get(‘Resolved at’)
END

2

Hi @rroades,

MDX CASE condition has problems when some of the arguments are a direct call for the property, but the other is a Measure - it cannot guess that this measure is returning the property as well. Please try to change the formula as follows (and make sure to set the formatting of the result to be a date)

CASE WHEN IsEmpty([Issue].CurrentHierarchyMember.Get("Resolved at"))
THEN [Issue].CurrentHierarchyMember.Get("Due date")
ELSE [Issue].CurrentHierarchyMember.Get("Resolved at")
END

Lauma / support@eazybi.com