Forum Discussion
Date Hierarchy for multiple datetime columns - inconsistent behavior
I have data coming from SQL. The table in SQL has multiple columns of type "datetime". I imported the data (it is not Direct Query). I have created a Date table, and defined relationships. I believe...
BhaveshPatel
Super User
Super UserI would suggest you to create a date hierarchy based on your Calender Table. Create Relationships between the Calender Table and your fact table.
You can also make inactive relationships active by using USERELATIONSHIP function.