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

  • March 14, 2013 at 11:10 am

    #1597158

    It's probably how I would have done it

    Alternatively you could do

    MEMBER [Measures].[Yearly Adv Req] AS

    (Descendants(Ancestor( [Date].[Calendar].CurrentMember, [Date].[Calendar].[Year] ),2).Item(0)

    , [Measures].[Advertising Req] )

    Mack