The correct answer is to create a calculated column using the CALENDAR function to generate a continuous date range. This is essential because time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR require a contiguous date dimension with no gaps; the CALENDAR function automatically produces every date between a specified start and end date, filling in missing dates that the source data might skip. On the Microsoft Power BI Data Analyst PL-300 exam, this concept tests your understanding of how to properly structure a date table for accurate time-based calculations—a common trap is relying solely on the source data’s Date column, which may have gaps, leading to incorrect YTD or QoQ results. A helpful memory tip: think of CALENDAR as your “date safety net” that catches every single day, ensuring your time intelligence never trips over missing rows.
PL-300 Prepare the data Practice Question
This PL-300 practice question tests your understanding of prepare the data. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
You need to create a Power BI data model that includes a date dimension. The source data contains a table with a Date column covering 2015-2025. You want to ensure that all dates in the model have a contiguous range for time intelligence. What should you do?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create a calculated column using CALENDAR to generate a continuous date range and use that.
Option C is correct because the CALENDAR function generates a contiguous range of dates, which is essential for accurate time intelligence calculations (e.g., YTD, QoQ). By creating a calculated column with CALENDAR, you ensure no gaps exist in the date dimension, even if the source data has missing dates. This approach allows you to mark the table as a date table and enable DAX time intelligence functions like TOTALYTD or SAMEPERIODLASTYEAR.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Hide the existing Date column and rely on auto date/time.
Why it's wrong here
Auto date/time creates hidden date tables, but it may not cover the full range if data is sparse.
✗
Add a calculated column for year and month from the existing Date column.
Why it's wrong here
Calculated columns for year/month do not create a contiguous date table.
✓
Create a calculated column using CALENDAR to generate a continuous date range and use that.
Why this is correct
A calculated table using CALENDAR creates a contiguous date range. Then mark it as a date table.
Related concept
Read the scenario before looking for a memorised answer.
✗
Use the existing Date column as the date table and mark it as a date table.
Why it's wrong here
If the existing Date column has gaps, time intelligence may not work correctly.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often think marking an existing date column as a date table (Option D) is sufficient, but they overlook the requirement for a contiguous range, which is critical for time intelligence to work correctly.
Detailed technical explanation
How to think about this question
Under the hood, DAX time intelligence functions like DATEADD and DATESBETWEEN rely on a contiguous date table marked as a date table in the model. The CALENDAR function generates a table with a single column of dates from a start to an end date, which can then be used to create a proper date dimension with additional columns like Year, Month, and Quarter. In real-world scenarios, source data often has missing dates (e.g., weekends or holidays), and without a contiguous date table, functions like PREVIOUSMONTH may skip days, leading to inaccurate aggregations.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Prepare the data — This question tests Prepare the data — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Create a calculated column using CALENDAR to generate a continuous date range and use that. — Option C is correct because the CALENDAR function generates a contiguous range of dates, which is essential for accurate time intelligence calculations (e.g., YTD, QoQ). By creating a calculated column with CALENDAR, you ensure no gaps exist in the date dimension, even if the source data has missing dates. This approach allows you to mark the table as a date table and enable DAX time intelligence functions like TOTALYTD or SAMEPERIODLASTYEAR.
What should I do if I get this PL-300 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You have a Power BI dataset that includes a date table created using CALENDAR(). You need to ensure that the date table always covers the full range of dates present in the fact table, even after new data is loaded. What should you do?
medium
A.Use a fixed start and end date in the CALENDAR function
B.Create a disconnected date table
✓ C.Create the date table using CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date]))
D.Enable Auto Date/Time in the model
Why C: Option C is correct because using `CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date]))` dynamically computes the date range from the fact table's actual data. This ensures that when new data is loaded with dates outside the previous range, the date table automatically expands to cover the full range, maintaining referential integrity for time intelligence calculations.
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.