I am connecting to Microsoft Analysis Services Cube , for reporting I need to Show Amount For Year Till Date and Same Period Last Year . Also the same has to be dynamic.
Example : YTD Amount should be January 2016 till 7 July 2016 and Same Period Last Year Amount should be January 2015 till 7 July 2015
I am not aware how should I create the calculated member (MDX query) to get the correct output. After searching a lot online I do get some query syntax but it gives me null output.
Also The Date Hierarchy That I have has the Last Value as Month Name and the output of it is like January 2016. There is no date member available in the Cube.
Getting the output if I create a hard corded MDX as below
Current YTD Sum(([January 2016]:[July 2016]),[Measures].[Amount])
Any help would be appreciated.
Could you upload a packaged workbook so we can take a look and see what you've tried? If you can't get a .cub file to do so, mock-data would help as well. If you have sensitive data, check out Anonymize your Tableau Package Data for Sharing. If you've already found a solution, please share!