topic Difference Between Years only for items alredy purchased in DAX Commands and Tips

Difference Between Years only for items alredy purchased

davidemeconi — Mon, 06 Jun 2022 12:57:32 GMT

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?

Re: Difference Between Years only for items alredy purchased

johnt75 — Mon, 06 Jun 2022 14:27:31 GMT

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.