Hi there - can someone please advise on how I can show a comparison of the same week last year? As you can see the dates could be one day up and down and I would like to show this on a line chart view. How can I make it look like the graph below with the above data?

sraj , With help from date table week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY)) Or have additional column in date table new columns Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense) ORWeek Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format measures This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1)) Last year Week= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=(max('Date'[Week Rank]) -52))) or Last year Week= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=(max('Date'[Week Rank]) -53))) Power BI — Week on Week and WTD https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123https://www.youtube.com/watch?v=pnAesWxYgJ8 Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hwhttps://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

same week last year comparison | Microsoft Fabric Community

Forum Discussion

Related content

Week over Week Comparison

Week on Week Comparison

BI Tools Comparison

Week comparison same week last year

Week comparison