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

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!