Yearly Value by Historic Years Automatically

[#1]

Hi Guys,

I calculate a value for spend by customers and compare against historic figures.

I have a set expression for each year at the moment

sum({<Year={'2012'}>}[Invoice Value])

sum({<Year={'2011'}>}[Invoice Value])

sum({<Year={'2010'}>}[Invoice Value])

etc

i would like to fix this in permanently rather than adding one each year going forward, for example using Year=(vToday)-1 , -2, -3, -4 etc for the past 5 years for example.

Any ideas how to achieve this?

[Anonymous · Accepted solution]

Sure, you can use:

sum({$<Year={$(=Year(Today())-X)}>} [Invoice Value])

Where X represents how many years you want to subtract from today.