PL-300 Prepare the data Practice Question
You need to create a date table in Power BI using DAX. Which function should you use to generate a continuous list of dates?
⚠ Common exam trap
Candidates often confuse CALCULATE (a context modifier) with CALENDAR (a table generator) because of the similar spelling, or they mistakenly think TODAY or DATEVALUE can produce a range of dates when they only return single values.
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
✓
CALENDAR.
The CALENDAR function in DAX generates a single-column table of dates that starts from a specified start date and ends at a specified end date, creating a continuous list of all dates in that range. This is the correct function to use when you need to create a date table for time intelligence calculations in Power BI.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
CALCULATE.
Why it's wrong here
CALCULATE is a context-modifier function that evaluates an expression under a changed filter context and returns a single scalar value. It does not generate a table of rows, so it cannot produce the continuous sequence of dates required for a date table. Even when used inside CALENDAR, you must supply a table-returning date function as the base, not CALCULATE itself.
- ✓
CALENDAR.
Why this is correct
CALENDAR is the correct DAX function because it explicitly returns a single-column table containing a continuous series of all dates from a specified start date to an end date, inclusive. This generated table can be used directly as a date table or extended with calculated columns for year, month, quarter, and other date attributes. It requires two date arguments, typically defined as DATE literals or scalar expressions that resolve to dates.
- ✗
TODAY.
Why it's wrong here
TODAY returns only the current system date as a scalar value, not as a table. While it can be useful as an argument to a table-generating function such as CALENDAR(DATE(2020,1,1), TODAY()), it cannot by itself create multiple rows or a range of dates. A date table requires a table object with many rows, so TODAY alone is insufficient.
- ✗
DATEVALUE.
Why it's wrong here
DATEVALUE is a type-conversion function that transforms a text string representing a date into a single date value. It is scalar, not a table-returning function, and therefore cannot generate a series of dates. You might use DATEVALUE to convert individual date text when building a date column, but it cannot replace CALENDAR for creating a date table.
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.