Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Display Last Year Same Week Data

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

Need Help
  • lukiz84's avatar
    lukiz84
    3 years ago

     

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

     

1 Reply

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

     

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