when is it acceptable to not have a contiguous date table?

[johnconnor]

Say I have a very simple table with column A showing first day of each month and column B with sales quantity. If I perform DATESYTD calculation - or any other time intelligence calculations for that matter - it should work, right?

When will not having a contiguous date table result in a failure of calculation?

Thank you!

 

[scottsen]

You fact table (with sales) doesn't need to be continuous. But your Calendar/Date lookup table... does need to be. It will mostly just throw errors at you without a "real" date table.