Mark as date table in Power BI - Step-by-Step Guide

Introduction

This feature lets you tell Power BI which table holds your date information. It helps Power BI understand time-based data better, so you can use time intelligence features like year-to-date or month-over-month calculations easily.

When you have a table with a column that contains dates and want to use time-based calculations.

When your report needs to show trends over time like sales per month or year.

When you want to use built-in time intelligence functions that require a proper date table.

When your data model does not automatically recognize your date column as a date table.

When you want to improve performance and accuracy of date-related filters and slicers.

Steps

Step 1: Click

- Model view in Power BI Desktop

The data model with tables and relationships appears on screen

Step 2: Select

- The table that contains your date column

The table is highlighted in the model view

Step 3: Click

- Table tools tab on the ribbon

Table tools options appear

Step 4: Click

- Mark as date table button

A dialog box opens asking to select the date column

Step 5: Select

- The date column from the dropdown in the dialog box

The selected column is set as the date column for the table

Step 6: Click

- OK button in the dialog box

The table is marked as a date table and Power BI uses it for time intelligence

Before vs After

Before

Date table is not marked; time intelligence functions may not work correctly or require manual setup

After

Date table is marked; time intelligence functions like YTD, QTD, and MTD work automatically and filters on dates behave correctly

Settings Reference

Mark as date table

📍 Table tools tab in Power BI Desktop ribbon

To specify which table and column Power BI should treat as the date table

Default: No table is marked by default

Common Mistakes

Marking a table that does not have a continuous date column

Time intelligence functions require a continuous date range without gaps

Ensure the date column has all dates in the range without missing days before marking as date table

Selecting a non-date column as the date column

Power BI needs a proper date column to recognize the table as a date table

Select a column with date data type and continuous dates

Summary

Mark as date table tells Power BI which table holds your dates for time calculations.

You must select a continuous date column to enable time intelligence features.

This improves accuracy and ease of working with dates in reports.