MDX Year to Date

I have a date heirarchy like this

dim date

Year

Quarter

Month

When i calculate YTD - 1, i get an error.. I read on the posts here that Parallel Period with YTD does not work properly..is it true?

SUM(YTD(ParallelPeriod([Dim Date].[Date].[Year],1, [Dim Date].[Date].CurrentMember)),[Measures].[SalesVolume])

Change the time dimension to your needs and try:

Gets YearToCurrentDate

Code Snippet

SUM(PeriodsToDate([DimTime].[Hierarquia].[Ano],
[DimTime].[Hierarquia].CurrentMember),
[Measures].[NC_ValorCarteira])

Gets Previous Member

Code Snippet

IIF(IsEMPTY(([Measures].[CM_ResFinAcum],[DimTime].[Hierarquia].PrevMember))
,0,([Measures].[CM_ResFinAcum],[DimTime].[Hierarquia].PrevMember))

Helped?

regards!

|||thanx Pedro..it worked

|||

YES!! :-)

mark your answer as resolved!

|||

mark your answer as resolved!