cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vistaprintpbi Frequent Visitor
Frequent Visitor

Same Week Last Year

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Same Week Last Year

@vistaprintpbi

 

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

1 REPLY 1
Highlighted
Super User
Super User

Re: Same Week Last Year

@vistaprintpbi

 

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