thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Date Dimension

A dimension with one row per calendar date and attributes such as year, quarter, month, weekday, fiscal period and holiday flag.

Definition

A date (calendar) dimension enables consistent time analysis and time intelligence. It should cover a contiguous date range with no gaps. Many models also add a separate time-of-day dimension.

Example

DimDate(DateKey 20261101, Date, Year, Quarter, MonthName, IsWeekend, FiscalYear)

Exam tip

DAX time intelligence requires a contiguous date table marked as a date table.

Related terms