MDX Year on Year

• reinhardcilliers

  SSC Eights!

  Points: 891

  More actions

  September 7, 2022 at 8:06 am

  #4084790

  Hi Guys

  Trust you keeping well.

  I have an issue with an meausre where we need to show the previous years data.

  Basically we need to compare a certain month on a daily basis the MTD value vs the previous year for the same month MTD per day.

  I am not that well versed in mdx and tried the following:

  CREATE MEMBER CURRENTCUBE.[Measures].[PY MTD Sales Value]

  AS Aggregate

  (

  PeriodsToDate( [Dim Date].[FiscalHierarchy].[Fiscal Month Name],

  ParallelPeriod(

  [Dim Date].[FiscalHierarchy].[Fiscal Year Name]

  ,1

  ,[Dim Date].[FiscalHierarchy].CurrentMember

  )

  )

  ,[Measures].[Actual Sales Value]

  ),

  VISIBLE = 1 ,  ASSOCIATED_MEASURE_GROUP = 'Sales';

  This does not seem to work 100%, as some days gets left out in the previous year and thus not displaying like for like per day current month vs previous year same month.

  I checked the days in both years and have dates available for all.

  Am I missing something perhaps?

  Any help would be appreciated.

  Thanks and kind regards

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  September 8, 2022 at 8:10 am

  #4085288

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.