Forum Discussion

Victormar's avatar
Victormar
Helper V
4 years ago
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...
Need Help
  • moizsherwani's avatar
    moizsherwani
    4 years ago

    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. 

moizsherwani's avatar
moizsherwani
Continued Contributor
4 years ago

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.