Forum Discussion
Model Design and Dates
Hi I have a data model that has a date table and fact tables. I am having issues with the model design. The date table needs to relate to the fact table by year and month, only this is not possible d...
I agree with jdbuchanan71 . However, I think you could also just do this with one date table. You could create a calculated column in your date dimension to reproduce the format of your period key in your fact table by using combinations of functions like YEAR, MONTH, WEEKNUM, and FORMAT. Then join the two on that key.
If you did that, add the YMW column to your date table, your join to your fact table would be many to many unless I am not understanding your post.
Oh jeez. You are 100% correct. I completely overlooked that. Good call! Thank you 🙂