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.

Kaviraj11's avatar
Kaviraj11
Solution Sage
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.

alycianw's avatar
alycianw
Frequent Visitor
2 years ago

That worked, thank you so much!

But I have one more question. Do you know why now my year / month name are not in the correct order?