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'm trying to do a YoY Comparison for 2021 and 2020, so when I use the sameperiodlastyear it compares the exact same date last year but I want it to calculate one day ahead
For Ex: My date range is 19 Dec 2021 to 25 Dec 2021, it should compare 20 Dec 2020 to 26 Dec 2020
Kindly help!
Solved! Go to Solution.
@Naveeduddin , Try a measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
If I may suggest other than the below, if you have calendar table with week number column, you can compare it by utilizing the same week number last year.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you! This was helpful
Wow, Amazing! This worked. Thanks a lot
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
If I may suggest other than the below, if you have calendar table with week number column, you can compare it by utilizing the same week number last year.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Not by a computer however SAMEPERIODLASTYEAR returns a table of dates. I think you should just be able to wrap it in DATEADD.
Can flesh that out later if you need?
@Naveeduddin , Try a measure like
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |