Mark as date table in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does 'Mark as date table' do in Power BI?

It tells Power BI which table contains valid dates for time intelligence calculations like year-to-date or month-to-date.

beginner

Why is it important to mark a table as a date table?

Because Power BI needs to know which table has continuous dates to correctly calculate time-based measures and use built-in time intelligence functions.

beginner

What column must a date table have to be marked as a date table?

It must have a column with unique dates and no gaps, usually a Date column with continuous daily dates.

beginner

How do you mark a table as a date table in Power BI?

Go to the Modeling tab, select 'Mark as Date Table', then choose the column with unique dates.

beginner

What happens if you don’t mark a date table in Power BI?

Time intelligence functions may not work correctly or give wrong results because Power BI won’t know which dates to use.

What is the main purpose of marking a table as a date table in Power BI?

A To create relationships automatically

B To sort data alphabetically

C To filter numeric columns

D To enable time intelligence calculations

Marking a table as a date table allows Power BI to perform time intelligence calculations like YTD or MTD.

Which column should you select when marking a date table?

A A column with duplicate dates

B Any text column

C A column with unique, continuous dates

D A numeric ID column

The date column must have unique and continuous dates for correct time intelligence.

Where in Power BI do you find the option to mark a table as a date table?

A Data tab

B Modeling tab

C View tab

D Home tab

The 'Mark as Date Table' option is under the Modeling tab.

What can happen if you don’t mark a date table but use time intelligence functions?

A Functions may return incorrect results

B Power BI will crash

C Data will be deleted

D Nothing will happen

Without marking a date table, time intelligence functions may not work properly and give wrong results.

Can you mark multiple tables as date tables in one Power BI model?

A No, only one table can be marked as date table

B Yes, any number of tables

C Only if they have the same columns

D Only if they are linked

Power BI allows only one table to be marked as the official date table.

Explain why marking a table as a date table is important in Power BI and how it affects time intelligence calculations.

Think about how Power BI knows which dates to use for calculations like year-to-date.

Describe the steps to mark a table as a date table in Power BI.

Remember the menu location and what column to pick.