MDX Year on Year

  • 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:


    AS Aggregate


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


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


    ,[Dim Date].[FiscalHierarchy].CurrentMember



    ,[Measures].[Actual Sales Value]



    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

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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply