Ho to calculate YTD to get data upto current month

• Mkrish

  Ten Centuries

  Points: 1256

  More actions

  October 14, 2014 at 3:12 am

  #312184

  Hi i created an ssrs report using mdx queries

  in that i have to calculate YTD to calculate data upto current month

  i wrote below query

  MEMBER [Measures].[YTD] AS (SUM([Date].[Fin Year Month Name].&[01April]:[Date].[Fin Year Month Name].&[07October],[Measures].[Amount]))

  but i want dynamical updation i.e., for next month it has to take upto november

  can any one please suggest me how to do this....

• PB_BI

  SSCoach

  Points: 17461

  More actions

  October 15, 2014 at 8:00 am

  #1752543

  There are a couple of ways to achieve this, depending on the setup of your date dimension. Have a look at the YTD and PERIODSTODATE functions:

  http://msdn.microsoft.com/en-us/library/ms146039.aspx

  http://msdn.microsoft.com/en-us/library/ms144925.aspx

  This is a common use for MDX so if you google it you will find absolutely loads of examples.

  ---

  I'm on LinkedIn