hi

[abc_777]

hi,

Please help me to calculate 

same week but previous year measure

so i can compaire 

2023 sale by week number to compaire 2022 sale by week number (head to head Weekly sale comparison)

Week number	2023 sale	same week previous year sale	2022 for referance same week previous year sale ( no need to show this in calculation, this is just a check)
1	2	1	1
2	3	3	3
3	4	4	4
4	5	5	5
5	6	5	5

thanks,

[Ritaf1983]

Hi @abc_777 ,
Any of the two solutions in the attached links may be helpful
https://www.youtube.com/watch?v=pgjnWBqZuNo
https://datacornering.com/get-data-from-same-week-last-year-in-power-bi/

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[abc_777]

hi,

the link you given he create a table and two measures where he use sales amount column but i want to use measure insteal of sales amount column

Week Table =

  SUMMARIZE(

                BMCalendar,BMCalendar[Year], BMCalendar[Week Number], "Week Total",

    CALCULATE([Total in Piece and KG (Measure)],   <<<< this is my measure i want to use

    ALLEXCEPT(BMCalendar, BMCalendar[Year], BMCalendar[Week Number])))

please help me how to do

thx