How to get the total sum of accounts until a certain date?
In DeepSee, having a customer account cube. The cube includes a time dimension AccountCreationDate.
How do you create a calculated measure to get the total number of accounts from the beginning to a certain date in abscissa ?
I tried many things including this: AGGREGATE(%TIMERANGE([AccountCreationDate].[H1].[MonthYear].&,[AccountCreationDate].[H1].[MonthYear].CURRENTMEMBER) ,[Measures].[%Count])
But I don't get the right result because the date in abscissa creates a filter on the first date.
I tried also with %MDX function, but then I loose the context for the CURRENTMEMBER.