Offset and variables

[Hanee]

Hi everyone, I am new to PowerBI and am trying to get ideas for making my work routine easier.

I want to make a variable for last week with OFFSET and then, make week on week for comparison as below.

However, though the first one for making VAR lw session_dax_VALUE)  is working, the entire one is not working.

Could you please help me? Thanks in advnace!

measure =

VAR lw_session_dax_VALUE =

    CALCULATE(sum('PL_Channel'[session]), offset (-1, , ORDERBY('PL_Channel'[yyyyww], asc) , , partitionby ('PL_Channel'[channel])))

var result = [lw_session_dax_VALUE]

RETURN  

    result

[lbendlin]

yyyyww will not work across year boundaries. Instead, use steps of 7 on your day column, and use WINDOW instead of OFFSET.