Current Year week to Last Year same Week

Hi Kundan_RR  - I hope you have a seperate date table with year and week number concatenate. 

YearWeek = Year & "-" & WeekNum

Please find the attached pbix file.

Hope this helps.

Hi Kundan_RR 

Below are the steps to follow:

1. Create Date table

Date =
ADDCOLUMNS (
  CALENDAR ( DATE(2024,1,1), DATE(2025,12,31) ),
  "ISO Week", WEEKNUM ( [Date], 21 ),
  "ISO Year", YEAR ( [Date] - WEEKDAY ( [Date], 2 ) + 4 ),
  "Year-Week", FORMAT ( YEAR ( [Date] - WEEKDAY ( [Date], 2 ) + 4 ), "0000" )
                 & "-" & FORMAT ( WEEKNUM ( [Date], 21 ), "00" )
)

Mark this as Date table and relate it with your Sales table on OrderDate.

2. Measures

Total Sales = SUM ( Sales[Amount] )

LY Same Week Sales =
VAR CurYW = SELECTEDVALUE ( 'Date'[Year-Week] )
VAR CurYear = VALUE ( LEFT ( CurYW, 4 ) )
VAR CurWeek = VALUE ( RIGHT ( CurYW, 2 ) )
RETURN
CALCULATE (
  [Total Sales],
  KEEPFILTERS (
      FILTER ( ALL ( 'Date' ),
          'Date'[ISO Year] = CurYear - 1 &&
          'Date'[ISO Week] = CurWeek
      )
   )
)

3. Visual

• Put a Slicer on Date[Year-Week] (single select).
• Add a Clustered column chart with:
  • X-axis >> Year-Week
  • Values >> Total Sales and LY Same Week Sales

Now when you select e.g. 2025-34 in the slicer, you’ll see two bars side-by-side:

• Current Year (2025-34) sales
• Last Year (2024-34) sales

4. Optional polish

• Rename measures to “Current Year” and “Last Year” for a cleaner legend.
• Add a dynamic title:

Chart Title =
"Year-Week: " & SELECTEDVALUE('Date'[Year-Week]) & " - Current vs Last Year"

I want my visual like this

Hi Kundan_RR ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

Do you want to show 2025-34 and 2024-34 as the legend and not just current/previous year?

Hi Kundan_RR,

In case, you'd like to have a dynamic legend, you could just use the KPI boxes as legends as those are dynamic and changes as and when you change the filter