Forum Discussion
Solved
Not able to use Calendar Table
Hi community, I have been dealing for some days with a problem when connecting a calendar table I create to some data tables that I have within my model. I have never experienced this problem, so...
Victormar I can't say exactly without looking at your data model but when I faced this issue in the past, it was because the date column were different (even though they looked the same). E.g. one might be coming through as a datetime and the other as a date so PowerBI doesn't understand that 1/1/2022 is the same as 1/1/2022 00:00. Let me know if this helps. If not please try to send over the data model with the two tables in question.
Indeed! That was actually the problem, in the Power Query one of the Date columns was marked as Date/Time, many thanks!