I am trying to use a Case statment and returning an Aggregate of dates, but it doesn’t work as I expected. My calculated member is like this:
CASE WHEN Day(Now()) <= 7 THEN
[Time].[Month].DateMembersBetween(‘4 months ago’, ‘today’)
[Time].[Month].DateMembersBetween(‘3 months ago’, ‘today’)
The name of the calculated member is “Last 3 or 4 months” and the result is like this:
As you can see it doesn’t show the ‘+’, to see how many issues where created each month, it only shows the total of the aggregation.
How can I do this calculated member to show the Aggregate with the ‘+’ symbol?