Forum Discussion
Previous Years vs Current Year
Hi, I want to compare current year's sales vs last year's sales. I am not 100% clear on how time intelligence features work. I have a "Years" that has the year, year beginning date & year end...
I believe you might have better luck with DATEADD, -1, year) intead of previous year.
Be carefull with DATEADD! It will only compare similar days between the two periods. For instance, in the first year you only have records on 200 days and the current you have records on 260 days. Using DATEADD will ignore the records that happened on days not present in the prior period.
Instead, use PARALLELPERIOD(). Same syntax as DATEADD without the nasty side effect.