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.
I'm creating a current and prior year trend chart using measures from another Power BI Dataset as a source. The Prior Year measure used from the other dataset is not showing the actual prior year event counts. Instead, it is also showing the current event counts.
The PY calculation from the other dataset is as follows:
Hi,
Ensure tha the DOWNTIME_EVENTS_BY_DEPARTMENT column:
Thanks for your reply.
Date table should be ok. It is generated based on Calendar function. Has lots of future dates and contains more historical dates than my event data:
I'd follow @Ashish_Mathur suggestion and make sure date columns in your new model are all set as Date and not Datetime. If that doesn't work come back and we'll see if we can dig deeper 🙂
Based on the error I'd start by checking your date table. Date time functions require full years. Eg even if you only step over onto 2nd of january your date table would need all dates in that year.
It's also possible that your date table is missing some dates.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |