Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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.

 

prevyear.JPG

 

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

1 ACCEPTED SOLUTION
lukiz84
Memorable Member
Memorable Member

 

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

 

View solution in original post

1 REPLY 1
lukiz84
Memorable Member
Memorable Member

 

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors