The majority of my apps run off the same master calendar which uses Boolean variables for "Current Fiscal Year to Date" and "Last Fiscal Year to Date".
To arrive at those values I first calculate a Fiscal date from the current date:
date(addmonths(($(vMinDate) + RowNo() - 1, -3)) as FiscalDate
Then I use the function
InYearToDate(FiscalDate, AddMonths($(vToday), -3), 0) * -1 as CurrentFiscalYearToDate
InYearToDate(FiscalDate, AddMonths($(vToday), -3), -1) * -1 as LastFiscalYearToDate
This works well, however now I need to use Fiscal Year as a dimension so I need a "Fiscal Year to Date" flag that is regardless of year. My set analysis needs to change from:
{< CurrentFiscalYearToDate = {1} >}
to:
{< FiscalYearToDate = {1}, FiscalYear = {2014} >}
