If I understand you created a Parameter based on date - and the format is year and month like this
not you want to determine the YTD value of a measure based on the value in the parameter
the formula to use is like this
in detail it will return this - I just show 2016 and 17 to show it is working
if you just want the ytd total it looks like this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
ytd2_v10.2.twbx 1.2 MB
Thanks for helping.
I have done what you suggested but only 1 year data showed in workbook.
What I want is I want to filter only month.
Do I need to change the script ?