Same Week Last Year

[Anonymous]

Hi all!

I know this is a largely discussed topic, but I haven't been able to find a fix that works for me.

I'm trying to create a measure that calculates the amount of Impressions for the Same Week Last Year. I've treid many functions, but

I've never been able sort out the 1 day offset issue:

Last Calendar Week (or Week #2 2019) is  Jan 6 – Jan 12, 2019

Same Calendar Week Last Year (or Week #2 2018) was Jan 7 – Jan 13 2018

What I would like to achieve now is this: 

Ideally, the Last Year Week measure should calculate the following:

1. Take the First day of the Current Year Week Num (Jan 6, 2019), and take it 364 days back.
2. Take the Last day of the Current Year Week Num (Jan 12, 2019), and take it 364 days back.
3. Return all the days that roll between the days obtained from steps 1 and 2 (i.e. from Jan 7, 2018 to Jan 13, 2018)

Can someone help me out in writing the DAX function for the above? Or provide other solutions? 

Thanks!

[Anonymous]

Can you please provide the complete code, if possible. Am also facing same probklem.

[AlB · Accepted solution]

@Anonymous

Have you tried:

DATEADD ( DATEADD ( 'Date'[Date]; -1; YEAR ); 1; DAY )

That should give you the dates you're looking for if the filter context is the week in 2019