Help with MDX using Stat Account in a specific time member

#21

thanks everyone for giving the rest of us some new ideas!

#22

Hi Navid and Justin,
Yes I have a similar MDX formula for one of my cubes that track my main KPI of the business.
I used a cumulative formula w MDX on time dimension very similar to Navi suggestion.

1 Like
#23

Thank you for sharing this question. Helpful insight!

#24

Looks like a response was already provided, Thank you Navin for sharing that with all of us!

1 Like
#25

The MDX function to use for this is ClosingPeriod. Here is how I use it:

	ClosingPeriod(
		[Time].[Default].[Month],
		Ancestor(
			[Time].[Default].CurrentMember,
			[Time].[Default].[Year]
		)
	)

This will return December (in my hierarchy) each time. If you ever need to return the amount in January then use OpeningPeriod instead.

1 Like