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.
Hoping to get some help here on an issue I have never seen.
Typically, I use SAMEPERIODLASTYEAR and setup a specific calendar table for all my Power BI reports. No issues with any other report but this one I am currently working on.
This issue creates errors across the entire report, but it can be distilled down to when I run the SAMEPERIODLASTYEAR calcuation (on a date such as 3/23/2020), it returns the end of the month of the previous year (3/31/2019), instead of my desired date (3/23/2019).
The below screenshot is what is occurring. My calendar table currently has not relationships to any other tables.
First Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Second See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |