Have a need to display values that are associated with a date range (target), the year-end value AND the next years values.

Thesse are more or less sales goals.  The monthly weighted values are pulled for a specific range of months.  Each of these monthly values also has a year-end value associated with it.  That works fine.  However, I also now need to show the year-end value for those same dimensions but associated with the following year.  I suppose I could do this with a calculated mesasure and use a condition of the year being 1 + the current year?

thoughts?

Hi,

Try using the index value in parallel period as -1 or required negative value to get the future years. Below is the sample query from Adventure Works

SELECT ParallelPeriod ([Date].[Calendar Year].[Calendar Year]
      ,-1
	  , [Date].[Calendar Year].&[2007])
   ON 0
   FROM [Model]