Forum Discussion
Help with Date table
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
That is a lot of work to create a calendar/date table when DAX has CALENDAR and CALENDARAUTO and a ton of other nice date functions like WEEKNUM, WEEKDAY, etc. Do you really need every minute of every day? I'll give your code a shot and see what I come up with though.
- I was just playing with it again after posting and I was able to utilize in a report with only dates. I have date and time in my fact tables so I just thought I need to replicate it for the relationship.
You bring up a good point about the DAX functions, I guess I should just build up the basic table.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.
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
