Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Can someone help me out in writing the DAX function for the above? Or provide other solutions?
Thanks!
Solved! Go to 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
Can you please provide the complete code, if possible. Am also facing same probklem.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |