Difference Between Years only for items alredy purchased

[davidemeconi]

hello,

i have a table with all the purchasing order that look like this:

now i want to compare the difference beetween two years but only for the item that was alredy purchased a year before a given date

is it possibile with dax or i have to work with the data structure?

[johnt75 · Accepted solution]

You can create a measure like

Sales of prior year products =
var latestYear = MAX( 'Date'[Year])
var priorYearProducts = CALCULATETABLE( VALUES('Orders'[Code]), 'Date'[Year] = latestYear - 1)
return CALCULATE([Sales Amount], priorYearProducts)

and you can build similar logic into comparison measures etc.