I have a project that started on July 2018, with daily data for sales. We would want to include a comarison with the sales for 2018 (July to December 2018) against the sales form 2019 (January up to today).
For 2019 data I am using the Quick Measure for Total Year To Date and everyhing works great.
However, I am struggling enormously with the formula for the data for 2018. I have tried the following:
1. Of course, if I include a hard coded 2018 as a condition in the Calculate, the filters don't work.
2. I have tried with SAMEPERIODLASTYEAR, as everyone recommends, but in my case, as I don't have data for a full year, is not viable.
3. I tried DATEADD from my Dates table, but I only get blanks.
Date.[Date], -1, YEAR))
Do you have any suggestions on another method that I could use?