Results 1 to 3 of 3

Thread: Mtd In Mdx

  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: Mtd In Mdx

    Friends

    I have a situation here, i have scenario and i am not great at MDX, please advise

    The scenario of my calculation is based on to creat a measure MOnth to date,

    Month To Date should be a running average of all responses for the reporting month to date so if the month is defined as running from 03/28/2007 to 04/27/2007 (these are not actual values), the month to date on 04/10/2007 would be the sum of all data from 03/28 to 04/10.



    YTD works in the same fashion, but is based from Jan 1 to the latest date (or the date selected for the report).



    But when i run this query , it does is take Avg of Mtd





    AVG(

    MTD(),

    [Measures].[Q1_Avg]

    )



    Which offcourse is not the situation , please advise and how do i limit the paramenter from 1+ Jan for year.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Do you have a calendar table to demarcate the months according to your business' requirement?

  3. #3
    Join Date
    Mar 2008
    Posts
    11
    Yes i do have a calander table to demarcate the months according to month requirment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •