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:
Can someone help me out in writing the DAX function for the above? Or provide other solutions?
Solved! Go to Solution.