Forum Discussion
Solved
Star Schema: Multiple Dates
Hello, everyone! I am in the beginning stages of creating a large workbook that will contain more than ten tabs on the Report View. The data uploaded is well over 100K rows of data. (I cannot share ...
Nothing wrong with having multiple date tables. Particularly if you want to use more than one of then at a time, or don't want to over complicate measures. They tend to be quite small.
The advantage of a single date table is when you want to have measures that involve different date but have to be on the same access. For example order and sales dates. You want the count of sales to be on the date they sales occur and orders on the the day those occured. A common date table would be required in that case, with measures that involve userelationship() to activate a relationship
Gotcha. Multiple date tables it is! Thanks for the confirmation, Deku! 🙂
(If anyone disagrees, please add your comment and reason for a healthy dialogue.)