Our data warehouse is always one day behind. This makes true inYTD comparisons unequal unless I subtract.
For example, on 4/2. If I'm doing a comparison between the current year and the previous year, I'm comparing data up to 4/1 in the current year but 4/2 in the previous year.
I'm using an auto-calendar but I don't see a "DaysAgo" option.
This is my current set analysis for the previous year's Sales measure. I need this to be inYTD, 1 year ago, but also one day before to make it equal. Does anyone have any recommendations?
Sum( { $< [INV_DATE.autoCalendar.InYTD]={1}, [INV_DATE.autoCalendar.YearsAgo]={1} > } [SALES] )
