This content has been marked as final. Show 2 replies
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.