Calculate the measure for the previous analysis week

[daniel_19]

Hello,

How can I calculate the "Value Begin" measure when it always has the same value as the "Final Value" of the previous week of analysis.

In this example the "Final value" is 80,30,30 for the analysis week 26 Dec to 01 Jan and for categories x,y,z. So the "Value Begin" for the following analysis week (02 Jan to 08 Jan) should be 80,30,30 for category x,y,z.

How to do this in Dax?

I tried with OFFSET

CALCULATE([Final Value],
OFFSET(
-1,
ALLSELECTED(d_calendar[Analyze week]),
GROUPBY(d_calendar[Analyze week]))
)

but doesnt work, returned blank

[daniel_19 · Accepted solution]

I solved.

it is necessary to create a classifier, for using OFFSET in the ORDERBY, I concatenated the year of the end of the week from the column date with the week of the year of the end of the week from the column date and then used offset:

CALCULATE([Final Value],
   OFFSET(
    -1,
        ALLSELECTED(
            'd_Calendar'[Concat(Year-Week(EndofWeek)],
            'd_Calendar'[Week analyze]),
       ORDERBY('d_Calendar'[Concat (Year-Week(EndofWeek)]
              )
)

d_calendar below: