2 Replies Latest reply on Jul 28, 2017 3:56 AM by Niranjan Banarjee

    Microsoft Analysis Services Cube: MDX Calculation for YTD,MTD

    Anderson Chikosha

      Hi guys

       

      I've recently started using cubes and was wondering if anyone can help with mdx calculations for MTD & YTD for both current and prior year possibly using a "reporting month" parameter.  I have tried following instructions on here Microsoft Analysis Services Cube: MDX Calculation for YTD,MTD and Today() posted by . Indumon   but I keep getting blanks.  I have attached a pix with the description of my Date Hierarchy as cannot upload a workbook.

       

       

      cheers