1. The current QuarterYear should be FY19 Q2 but its showing FY19 Q3 also which logically wrong. How to fix this issue?
In your expression for Quarters Use Floor instead of Ceil
2. I want to re frame my QuarterYear format from FYQ2-2018-2019 to FYQ2-2019. Because my model has a data for 2016 butitsnot showing 2016 option due to the format of my QuarterYear. How to fix this too?
I didn't your question right. For 2016 data, use 2016 Jan 1 as your start date
LET vStartDate = Num(Floor(YearStart(Today(), -2)));
And then to remove additional dates left join the calendar to your data model.