Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Sure, you can use:
sum({$<Year={$(=Year(Today())-X)}>} [Invoice Value])
Where X represents how many years you want to subtract from today.
Sure, you can use:
sum({$<Year={$(=Year(Today())-X)}>} [Invoice Value])
Where X represents how many years you want to subtract from today.