Home Forums Data Warehousing Analysis Services Calculated Member - Current month RE: Calculated Member - Current month

  • July 2, 2015 at 12:27 pm

    #1810028

    I haven't tested this, but how about something like:

    ...and SetToStr([Dim Date].[FSCL_YR].[FSCL_YR].currentmember) = "[Dim Date].[FSCL_YR].&[" + Format(now(), "yyyy") + "]"