SSAS Dynamic Prior Period

Josh,

When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax:

CREATE MEMBER CURRENTCUBE.[Measures].[View Count - Prior Period]

AS (

       ParallelPeriod (

              [Dim Date].[Calendar Year Hierarchy].CurrentMember.Level

              , 1

              , [Dim Date].[Calendar Year Hierarchy].CurrentMember

       )

       , [Measures].[View Count]

)

This will allow the calculation to show Prior Year when looking at the year level, Prior Month when looking at the month level, etc.

Thanks to: http://xzwang.wordpress.com/2013/08/13/a-better-way-to-write-mdx-period-over-period-calculations/