I am trying to understand where the issue is. I tried the first part (MDT for 1 Year) and it works on my sample data.
Easiest way to help you is, that you create a sample data set and upload it to QuickSight Arena including your calculation and the parameters. Then we can work togehter on it.