Data engineering and IT

Date table

A table with one row per date, used so that time calculations work.

  • Data engineering and IT

Definition

A table with one row per date, used so that time calculations work. Without one, year-to-date and same-period-last-year quietly return wrong numbers.

For your role

Choose your role to see what this term means in your work.

Why it matters

Where it is used

Every Power BI model that reports on time, which is almost all of them.