Forum Discussion
Solved
Time Intelligence - compare to fixed year
Hi Power BI community! I am hoping someone can help me with my time intelligence problem. Due to COVID, we have a requirement to compare results to a fixed year, which for us is our Fiscal 2019 ...
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.
Thanks Ibendlin, this makes sense - yes I was trying to do Year over Year to Date all in DAX. Adding the dimensions to the date table has made this so much simpler, thank you!