I am trying to calculate sales for the previous year. I have made a variable as i thought it would be easier. When i make a selection i.e a month (feb 2017), i want this new measure to calculate the year before(Feb2016).
Currently it just shows the same sales as the selection made.
I have a date field,"Date1" and sales field "NetValue".