YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too

Written by Karan Gulati on 25 October 2010. Posted in MDX

with member [Date].[Calendar].[currentyear] as aggregate(ytd((strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")+"]"))))

member [Date].[Calendar].[prevyear] as aggregate(ytd(parallelperiod([Date].[Calendar].[Calendar Year] ,1,(strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")+"]")))))

select

YTD Based on Current System Date (Now() Function), based on same date pulling value for Last Year too

Similar Articles