A date table is a separate table with one row per day, containing columns such as year, month, quarter and weekday. Power BI uses it to make time-based calculations, such as year-to-date sales, work correctly.
Why it matters
Without a proper date table, measures that compare periods can give wrong totals or blank values. A dedicated table gives every report the same calendar.
Steps
- Create a table with one row for every day in the range your data covers.
- Add columns for year, month name, quarter and day of week.
- Mark it as a date table in Power BI, so time intelligence functions can use it.
- Create a relationship from your fact table’s date column to the date table.
Check the result by comparing one month’s total from the report with a simple SUM on the source data.
Learn the measures that use this table in DAX basics, and the modelling ideas in star schema for beginners. Book a free demo class, and ask a counsellor for the course schedule.
