I want show [Time].[Start] in [Measures] Dimension.
WHEN DateCompare([Time.Weekly].CurrentHierarchyMember.StartDate, DateParse([Time].[Start])) < 0
So I get correct result like this.
But I want not only “Pic” Project but also “Pic*” Projects.
So I create [Project].[All Pic].
And then, EazyBI makes error like this.
How can I get right result?
Hi @1115 ,
I recommend defining the date in Measures instead of a Time dimension calculated member. See the formula for a new calculated measure below:
Use one of the “Date/Time” formatting options to display it as a date. See more details on formatting here - Calculated measures and members - eazyBI for Jira.
Then you can reference the calculated measure instead of the Time dimension calculated member in the formula TEST4, without DateParse().
What information do you want to display in the calculated measure “TEST6”?
Roberts // email@example.com