Forum Discussion
Power BI Datasets
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 ev...
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:
DateDim =
VAR BaseCalendar =
CALENDAR( Date(2017, 1, 1), Date(2040,12,31))
There are gaps in the Event data but trending works fine in the source .pbix workbook/dataset. My real dilema is why the PY event counts in the linked dataset are not correct when used
in the destination workbook.
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 🙂