Forum Discussion

alycianw's avatar
alycianw
Frequent Visitor
2 years ago
Solved

Centralized Calendar

I am trying to connect a single table with a working centralized calendar table. I have created the basic calendar table, marked it as a Date Table, Created relationship between Calendar Table on the...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    What is the data type on system_created_dt in Change Request table?

     

    If it's a datetime, make sure to change it to date data type in the source or pwoer query.

  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello alycianw ,

     

    it's as Kaviraj11  mentioned, this behaviour occurs when the date type column is linked to the datetime column.

     

    and it's in your fact table and would only work when changed in Power Query.

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello alycianw ,

 

it's as Kaviraj11  mentioned, this behaviour occurs when the date type column is linked to the datetime column.

 

and it's in your fact table and would only work when changed in Power Query.