Posts

Showing posts from June, 2015

MDX: How to Calculate Last three Month Average

SUM(     LastPeriods(         3,         PARALLELPERIOD(             [Date].[CalenderHierarchy].[Month],             1,    Ancestor(                 [Date].[CalenderHierarchy].CURRENTMEMBER                ,[Date].[CalenderHierarchy].[Month]             )         )     )     ,[Measures].[Count] )
Post a Comment
Read more

MDX: How to Calculate Last Month Full data

SUM(     PARALLELPERIOD(         [Date].[CalenderHierarchy].[Month],         1, Ancestor(             [Date].[CalenderHierarchy].CURRENTMEMBER            ,[Date].[CalenderHierarchy].[Month]         )     ),     [Measures].[Count] )
Post a Comment
Read more