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

Are you using the month year column from Change Request table? If yes, make sure to use it from Calendar table.

alycianw's avatar
alycianw
Frequent Visitor
2 years ago

the bottom graph is using the year/month name from the calendar table, but it is now showing in chronological order,