CALENDAR MEASURE AND PREVIOUS YEAR

philgood34 — Thu, 31 Aug 2017 10:07:33 GMT

Let me explain my issue with a example (app joined)

I have 3 years with CATTC (sales if you prefer) each month

i want to compare for each month :

évolution CATTC of the year Vs prévious year

gap between CATTC of the year and goal (goals are datas in a table ) (here is not my issues)

well i did that after created a calendar measure with CATTC

I have 2 issues in my visualization :

if i select only 2016, sum cattc YTD = sum CATTC YTD last year as you see ??

Secondly

if i select 2017 ... there is no value in previous year

anyone have a idea ?

regards

PS : i have i another solution (thank's sunny) by script in another threads, but i want to progress using CALENDAR MEASURE

Re: CALENDAR MEASURE AND PREVIOUS YEAR

sunny_talwar — Thu, 31 Aug 2017 14:01:55 GMT

I have not checked the file, but check my response here: