Total sales of Last Year same week with Year Month and WeekNumber columns

[Raks]

Hi Team,

I have Year, Month and Week Number and Sales , I have to calculate last year sales of the same week.

Year	Month	Week	Sales
2022	1	1	10
2022	1	2	20
2022	1	3	30
2022	1	4	40
2022	1	5	50
2023	1	1	60
2023	1	2	70
2023	1	3	80
2023	1	4	90
2023	2	5	100

Result 

Year	Month	Week	Sales	Result
2022	1	1	10
2022	1	2	20
2022	1	3	30
2022	1	4	40
2022	1	5	50
2023	1	1	60	10
2023	1	2	70	20
2023	1	3	80	30
2023	1	4	90	40
2023	2	5	100	50

Thanks in Advance !

[Ahmedx · Accepted solution]

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiGHx5zKM5aY2ynCr?e=HIoAYq

[Raks]

@Ahmedx ,

I dont have any other table its just single table and no date column too, It has only Year,MonthNumber & WeekNumber.

Thanks!

[Ahmedx]

you must have a calendar table
if there is a calendar, then you can use

Measure = CALCULATE(SUM('Table'[Sales]) ,DATEADD(Calendar[Date],-1,YEAR))

to get the desired result