Forum Discussion

Joerobert's avatar
Joerobert
Advocate V
8 years ago
Solved

Help with Date table

Hello,   I don't really know the importance of date tables so I thought i would attempt to create one and apply to my data model as a trial run. Unfortunately i cannot get it properly set up. After...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Joerobert,

    You can create a normal calendar table as Greg_Deckler's post, and create a date type field using dax in your fact table, then create one-to-many relationship between calendar table and fact table.

    Do you get any issues using the above method?

    Regards,
    Lydia

Joerobert's avatar
Joerobert
Advocate V
8 years ago

I am looking at this again, using a date table while carrying date/time in my fact table and I am only seeing a relationship with the rows where the timestamp ends in 12:00:00 AM. It does look like I might need to carry a timestamp in my date table and therefore carrying a duration for every minute.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Joerobert,

You can create a normal calendar table as Greg_Deckler's post, and create a date type field using dax in your fact table, then create one-to-many relationship between calendar table and fact table.

Do you get any issues using the above method?

Regards,
Lydia

  • Joerobert's avatar
    Joerobert
    Advocate V
    8 years ago

    Thanks Lydia, i acutally performed this very same task to get my issues resolved; just coverted the original column in my fact table to date type and I am now able to bring in all the rows through the relationship.

     

    Thanks for your help!