PL-300 Prepare the data Practice Question
You are preparing a Power BI report that uses data from Azure SQL Database. The data includes a date column that needs to be used in time intelligence calculations. You want to ensure that the date column is recognized as a date table in the data model. What should you do?
⚠ Common exam trap
Many exam-takers confuse setting a column's data type to Date with marking the table as a date table, assuming the data type alone is sufficient for time intelligence, but Power BI requires explicit table marking to enable proper date filtering and DAX time functions.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
In the model view, mark the table as a date table by selecting the date column.
Marking a table as a date table in the model view explicitly tells Power BI that the table contains a complete set of dates for time intelligence calculations. This ensures that DAX functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD work correctly by using the marked date column as the primary date reference for the model, rather than relying on auto-generated date hierarchies.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set the data type of the date column to Date.
Why it's wrong here
Setting the data type to Date only affects how the values are stored and displayed in the model; it does not designate the table as a date table. To enable time intelligence functions, the table must be explicitly marked as a date table in the model view with a selected date column. Without this designation, the model may not treat date values as a contiguous date range, leading to inaccurate time-based DAX calculations.
- ✗
Use the DAX function DATEADD to create a date table.
Why it's wrong here
DATEADD is a time intelligence function that returns a shifted set of dates from an existing date column, not a table of dates. It cannot create a date table; the correct function for generating a date table is CALENDAR or CALENDARAUTO. Additionally, DATEADD requires a context of dates already in the model, so using it in this way is both syntactically and conceptually incorrect.
- ✓
In the model view, mark the table as a date table by selecting the date column.
Why this is correct
This is the correct action because marking a table as a date table explicitly tells Power BI which column represents the primary date and defines the table as the source for time intelligence functions. When a table is marked as a date table, Power BI validates that the column contains unique, continuous dates and uses it to enable functions like TOTALYTD, SAMEPERIODLASTYEAR, and RELATEDDAX date filtering. This designation ensures that relationships and calculations are aligned with the reporting date range.
- ✗
Create a calculated column using DATEVALUE to convert the date.
Why it's wrong here
DATEVALUE converts a text representation of a date into a date data type, but the result is simply a calculated column within the table. Creating a calculated column does not mark the table as a date table, which is a separate table-level property. Even if the column is correctly typed, time intelligence functions will not recognize the table as a proper date table unless it is explicitly marked in the model view.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.