Forum Discussion
Time Intelligence - compare to fixed year
We have a similar situation. Our data model includes a custom calendar table for our fiscal year, so it contains the Fiscal Year name which makes filtering easy.
Are you planning to compare against the full period in FY19, or are you planning to do a Year over Year To Date comparison? In that case you need to add a special flag to the FY19 dates to mark the ones that are "in the past" relative to the last invoice date, and then you add that flag as a filter.
Super UserWe have a similar situation. Our data model includes a custom calendar table for our fiscal year, so it contains the Fiscal Year name which makes filtering easy.
Are you planning to compare against the full period in FY19, or are you planning to do a Year over Year To Date comparison? In that case you need to add a special flag to the FY19 dates to mark the ones that are "in the past" relative to the last invoice date, and then you add that flag as a filter.