Display Last Year Same Week Data

[Anonymous]

Dear Experts

I have 2 fields in my report YearWeek & Sales. I would like to display last year same week data in a new column next to Sales.

*I do not have date in my of my tables it is only YearWeek YYYYWW.

Please can someone help me with the DAX code to achieve this or advise if any altertive option. Appreciate your help on this.

Thanks
Mahad

[lukiz84 · Accepted solution]

PrevYearSales :=
   CALCULATE(
      SUM(YourTable[Sales]),
      FILTER(
          YourTable,
          YourTable[YearWeek] = EARLIER(YourTable[YearWeek])-100
      )
   )