PL-300 Model the data Practice Question
You are building a Power BI semantic model that includes a Date table. Which of the following is a best practice for creating a Date table?
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
✓
Mark the date table as a date table in Power BI Desktop.
Option A is correct because marking a table as a date table in Power BI Desktop (via Table tools > Mark as date table) designates it as the model's official date table, enabling built-in time intelligence functions to work correctly and ensuring the table meets the requirements of a contiguous, unique date column. This is a documented best practice for any semantic model that uses time intelligence. Option B is wrong because relationships should be created between the date table and the date columns of fact tables, not to every date-bearing column, and a single active relationship per fact table is typical. Option C is not a best practice because CALENDARAUTO generates dates based on the model's data range, which can produce an unpredictable or incomplete range; a manually or Power Query–built date table with a fixed, contiguous range is preferred. Option D is wrong because a date table must contain a continuous, unbroken sequence of dates, not just the dates present in fact tables, so that time intelligence calculations over gaps work properly.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Mark the date table as a date table in Power BI Desktop.
Why this is correct
Marking a table as a date table in Power BI Desktop (via Table tools > Mark as date table) establishes it as the model's official calendar source. This designation is required for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN to operate correctly. Power BI validates that the chosen date column contains continuous, unique dates and automatically uses it for date-based calculations and hierarchy generation.
- ✗
Create relationships from the date table to every fact table column that contains dates.
Why it's wrong here
Creating relationships from the date table to every fact table column that contains dates is an anti-pattern because each fact table should have only one active relationship to the date table. Multiple active relationships would create ambiguous filter paths and cause DAX queries to return incorrect results. For secondary date columns, use inactive relationships with USERELATIONSHIP in measures, or create separate role-playing date tables to maintain clear and predictable filter propagation.
- ✗
Use the CALENDARAUTO function to automatically generate dates.
Why it's wrong here
CALENDARAUTO is a DAX function that infers the date range from all existing dates in the model, but it may not cover the full required range if fact tables have gaps or if you need to include future dates or fiscal dates. This can produce an incomplete date table, leading to errors in time intelligence calculations that assume a contiguous calendar. It's better to use CALENDAR with explicit STARTDATE and ENDDATE parameters to control the exact range and ensure all dates are present.
- ✗
Use a date table that includes only dates that exist in the fact tables.
Why it's wrong here
Restricting a date table to only dates that exist in fact tables introduces gaps in the calendar, which breaks the contiguous date series that time intelligence functions rely on. For example, TOTALYTD for a date with no transactions would still need a row to evaluate correctly. A proper date table must include all dates for the desired reporting range, including future dates for budget or forecast scenarios, to maintain consistent year-over-year comparisons.
Go deeper
Related to this question
About these practice questions
This PL-300 question is part of Courseiva's 524-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.