SELECT GENERATE(
  [Date].[Calendar].[Month].Members
  , {
      Ancestors([Date].[Calendar].CurrentMember, [Date].[Calendar].[Calendar Year])
    , Ancestors([Date].[Calendar].CurrentMember, [Date].[Calendar].[Month])
    }
  )
DIMENSION PROPERTIES MEMBER_TYPE ON 0
FROM [Adventure Works]

NonEmpty(
    Order(
        Descendants(
            [Date].[Fiscal Calendar].[All].Children,
            [Date].[Fiscal Calendar].[Month],
            SELF_AND_BEFORE),
        [Date].[Fiscal Calendar].CurrentMember.Member_Key,
        DESC)
    )