Home Forums Data Warehousing Analysis Services MDX First month of year RE: MDX First month of year

  • March 10, 2013 at 10:53 am

    #1595311

    I'm sure there must be a better way, but I did get this to work by:

    MEMBER [Measures].[Yearly Adv Req] AS

    (

    Ancestor( [Date].[Calendar].CurrentMember, [Date].[Calendar].[Year] ).FirstChild.FirstChild,

    [Measures].[Advertising Req]

    )

    Rob