Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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 Y...
Need Help
  • lukiz84's avatar
    lukiz84
    4 years ago

     

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

     

lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
4 years ago

 

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