A Power BI model has a Date table and a Sales table. To enable time intelligence functions, what is the mandatory requirement for the Date table?

Question

Power BI — Hard

A Power BI model has a Date table and a Sales table. To enable time intelligence functions, what is the mandatory requirement for the Date table?

Accepted Answer

To enable time intelligence functions in Power BI, the Date table must have a contiguous date column with no gaps, marked as a Date Table. This requirement ensures accurate calculations. Option B is correct because it allows for proper date hierarchy and filtering. Options A, C, and D are incorrect as they don't guarantee contiguous dates or proper table marking.