Creating a Date Table in Power BI
Which TWO of the following are valid ways to create a date table in Power BI?
Quick Answer
Building a date table with Power Query's List.Dates function is one valid answer because it lets you generate a continuous, single-column list of dates directly in the query editor by specifying a start date, a count, and a step, which you can then load as a proper date table without ever leaving the data transformation environment. The other valid approach lives on the DAX side of the model: the CALENDAR function builds the same kind of single-column date table from explicit start and end dates you supply, while CALENDARAUTO scans the rest of the model automatically and infers the date range it needs to cover. What ties these two approaches together, and what makes them the valid pair here, is that both produce the same end result, a clean table of contiguous dates suitable for a date dimension, just through different tools: one operates during data loading and shaping, the other operates inside the model after data is loaded. Recognizing this distinction matters for exam scenarios that ask for multiple valid methods to reach an identical result: expect the correct answers to be different tools that solve the same problem rather than one correct method and one plausible-sounding distractor, and look specifically for functions and techniques that guarantee continuity, no gaps and no duplicates, across the full date range required.
⚠ Common exam trap
Test-takers frequently confuse time intelligence functions (like TOTALYTD) with table creation functions, or they assume that marking a table as a date table or enabling auto date/time actually creates a new date table, when in fact those options only configure existing data.
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
✓
Using DAX function CALENDAR or CALENDARAUTO.
The DAX functions CALENDAR and CALENDARAUTO are specifically designed to generate a single-column table of dates, which can then be used as a date table. CALENDAR requires explicit start and end dates, while CALENDARAUTO automatically scans the model to determine the date range. Both are standard methods for creating a date table 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.
- ✗
Using the time intelligence functions like TOTALYTD.
Why it's wrong here
Functions use date tables, do not create them.
- ✗
Marking an existing table as a date table.
Why it's wrong here
Marks but does not create a date table.
- ✗
Enabling the auto date/time feature.
Why it's wrong here
Creates hidden date tables, not user-controllable.
- ✓
Using DAX function CALENDAR or CALENDARAUTO.
Why this is correct
Creates a date table with a range of dates.
- ✓
Using Power Query with List.Dates.
Why this is correct
Generates a list of dates in Power Query.
Go deeper
Related to this question
About these practice questions
One of 217 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
3 more ways this is tested on PL-300
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 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?
medium- A.Hide the existing Date column and rely on auto date/time.
- B.Add a calculated column for year and month from the existing Date column.
- ✓ C.Create a calculated table using CALENDAR to generate a continuous date range and mark it as a date table.
- D.Use the existing Date column as the date table and mark it as a date table.
Why C: The CALENDAR function creates a calculated table (not a column) that generates a contiguous range of dates, which is essential for accurate time intelligence calculations such as YTD or QoQ. After creating this calculated table, you can mark it as a date table to enable DAX time intelligence functions. Although the option wording mistakenly says 'calculated column', the intent is to create a separate date table using CALENDAR, which is the proper method to ensure no gaps in the date dimension.
Variation 2. You need to create a date table in Power BI using DAX. Which function should you use to generate a continuous list of dates?
easy- A.CALCULATE.
- ✓ B.CALENDAR.
- C.TODAY.
- D.DATEVALUE.
Why B: 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.
Variation 3. 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: 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.
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.