Forum Discussion
Solved
Running Comparion to previous year
Hi I need to establish the comparative volumes from the previous year against the current year. I think I am part way there but can't finalise the measure to achieve this. I know I need to...
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.
Hi Ashish
Finally solved it I think it was to do with my initial evaluation context anyway I have addressed that and created the following measure
PY VOLUMES = IF(LASTDATE('DATE'[Date]) > TODAY(), BLANK(),
CALCULATE( [YTD VOLUMES], DATEADD('DATE'[Date],-1,YEAR)))
Which has given me a running total that updates automatically.
Thanks for your help.
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.