Forum Discussion
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:
- Take the First day of the Current Year Week Num (Jan 6, 2019), and take it 364 days back.
- Take the Last day of the Current Year Week Num (Jan 12, 2019), and take it 364 days back.
- 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
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
2 Replies
- AlBCommunity Champion
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
- AnonymousNot applicable
Can you please provide the complete code, if possible. Am also facing same probklem.