5 Replies Latest reply on Feb 1, 2016 1:04 PM by Ravikant Pothukuchi

    How to do YTD and MTD calculations in MSAS cube?

    Ravikant Pothukuchi

      There are very less resources and examples pertaining this question.

      Please refer to the screenshot below. It shows the dimension and measure names of my cube.


      I referred to the link below for YTD and MTD calculations.

      Microsoft Analysis Services Cube: MDX Calculation for YTD,MTD and Today()

      I have been using the following calculated member to find out MTD

      SUM(MTD(Strtomember("[DIM TIME].[Date].&["+format(now(),"mm/dd/yyyy")+"]")),[Measures].[SALES AMOUNT])


      It does not give me any result.


      Note: This link is helpful too

      MTD & YTD Columns from Analysis Services Cube