Sales for manufacturers from last year

[GoingIncognito]

I need to compare YoY sales but for the manufacturers from last year. I tried this:

LYSales=
var LYManufacturers = CALCULATETABLE(values('Manufacturers'[Manufacturers]), sameperiodlastyear(Date[date]))
return
calculate([TotalSales], LYManufacturers)

but I get a wrong grand total. The grand total adds up the amount from all the previous years.

[GoingIncognito · Accepted solution]

I solved this like this:

LYSales=
var LYManufacturers = CALCULATETABLE(values('Manufacturers'[Manufacturers]), sameperiodlastyear(Date[date]))
return
calculate([TotalSales], LYManufacturers SAMEPERIODLASTYEAR(Date[date]) )

when I use it in a table with year-column, it works fine. But if and when you guys have better solutions, share them?
Thanks for reading this.

---

@GoingIncognito wrote:

I need to compare YoY sales but for the manufacturers from last year. I tried this:

LYSales=
var LYManufacturers = CALCULATETABLE(values('Manufacturers'[Manufacturers]), sameperiodlastyear(Date[date]))
return
calculate([TotalSales], LYManufacturers)

but I get a wrong grand total. The grand total adds up the amount from all the previous years.

---