Report on week over same week last month

[Stratford]

Hi

I am building a report to show the web data week by same week last month. I have created a Calendar table and added columns to show week number and week sequence number to avoid any issue with year boundairies. 

I enter the following formula, but when i table the numbers to sense check, they show the same as the current week.

Previous Period = calculate ( [Total Sessions], filter('Calendar', 'Calendar'[WeekSequenceNum] - 4))

Please help

[parry2k · Accepted solution]

@Stratford change your expression as below

Previous Period =
VAR sequenceNum = MAX( Calendar[WeekSequenceNum] )- 4
RETURN
 calculate ( [Total Sessions], 'Calendar'[WeekSequenceNum] = sequenceNum)

[Stratford]

Thanks Parry2k, works like a charm

When I try filter the data on a week offset to show weeks -1 to -5, ie the last 4 competed weeks. It reoves the previous period data. It also doesnt like it when i try to graph using the week commening dat on the axis.

Any thoughts?

Thanks