Forum Discussion
sshweky
Helper III
Helper IIIPrevious 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...
kcantor
Community Champion
Community ChampionI 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.