How to Create a Calculated Table in Power BI with DAX

Which are valid ways to create a calculated table in Power BI? (Select all that apply)

Quick Answer

The answer is SUMMARIZE(Sales, Sales[ProductID], "Total", SUM(Sales[Amount])) and CALENDARAUTO(). Both are valid ways to create a calculated table in Power BI with DAX because each returns a table object that can be assigned directly to a new table in the model. SUMMARIZE groups data by specified columns and adds a calculated aggregation column, while CALENDARAUTO generates a contiguous date table automatically from the model’s date columns. On the PL-300 exam, this tests your understanding that calculated tables are created using DAX functions that output tables—not measures or calculated columns. A common trap is confusing SUMMARIZE with ADDCOLUMNS or thinking CALENDARAUTO requires manual date range arguments. Remember: if a DAX function returns a table, it can define a calculated table. For the exam, think “table in, table out”—any function that outputs a table is a valid constructor.

⚠ Common exam trap

The trap is assuming only specialized table functions like CALENDARAUTO and SUMMARIZE are valid, while other table-returning functions like VALUES and FILTER are also perfectly valid for calculated tables. The key is to recognize that any DAX function that returns a table can be used.

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

✓

VALUES(Customer[Country])

To create a calculated table, you need a DAX expression that returns a table object. Options A, C, D, and E all return tables: VALUES returns a single-column table of distinct values; FILTER returns a filtered subset of rows; CALENDARAUTO returns a date range table; SUMMARIZE returns a grouped table with aggregations. Option B, CALCULATE, returns a scalar value, not a table, so it is invalid.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✓
VALUES(Customer[Country])
Why this is correct
VALID: VALUES returns a single-column table of distinct values from a column, which can be used to create a calculated table.
✗
CALCULATE(SUM(Sales[Amount]), ALL(Sales))
Why it's wrong here
INVALID: CALCULATE returns a scalar value, not a table, so it cannot be used to define a calculated table.
✓
FILTER(Products, Products[Color] = "Red")
Why this is correct
VALID: FILTER returns a table that is a subset of rows from another table based on a condition, suitable for calculated table creation.
✓
CALENDARAUTO()
Why this is correct
VALID: CALENDARAUTO is a dedicated function that returns a table containing a contiguous date range, commonly used for time intelligence.
✓
SUMMARIZE(Sales, Sales[ProductID], "Total", SUM(Sales[Amount]))
Why this is correct
VALID: SUMMARIZE returns a table with grouped data and aggregated columns, a standard calculated table method.

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 →

How Courseiva writes practice questions · Editorial policy

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. Which TWO of the following are valid ways to create a calculated table in Power BI? (Select TWO.)

easy

✓ A.Use the DAX expression with the SUMMARIZE function.
B.Use the Merge Queries feature in Power Query Editor.
C.Use the Split Column feature in Power Query Editor.
✓ D.Use the DAX expression with the ADDCOLUMNS function.
E.Use the Group By feature in a matrix visual.

Why A: The SUMMARIZE function in DAX creates a calculated table by grouping data from one or more tables, returning a new table with distinct combinations of the specified columns. This is a standard way to generate a calculated table in Power BI for further analysis or modeling.

Variation 2. Which TWO of the following are valid ways to create a calculated table in Power BI?

medium

✓ A.DATATABLE(...)
B.CREATE TABLE FROM (SELECT ...)
✓ C.SUMMARIZE(Sales, Product[Color], "Total", SUM(Sales[Amount]))
D.TABLE.COLUMNS()
✓ E.CALENDARAUTO()

Why A: A, C, and E are all valid DAX functions that return tables and can be used to define calculated tables in Power BI. DATATABLE creates a static table with specified data, SUMMARIZE groups and aggregates data, and CALENDARAUTO returns a date range. Options B and D are not valid DAX functions.

Variation 3. Which TWO of the following are valid ways to create a calculated table in Power BI? (Select two.)

easy

✓ A.Using the CALENDAR function to generate a date table.
✓ B.Using DAX expressions like SUMMARIZE or ADDCOLUMNS.
C.Using the 'New Table' button under the 'Modeling' tab and writing a Power Query expression.
D.Using M language in Power Query Editor.
E.By right-clicking a table in the Fields pane and selecting 'New calculated table'.

Why A: The CALENDAR function is a DAX function that can be used to create a calculated date table. Option B is correct because DAX expressions like SUMMARIZE and ADDCOLUMNS can be used to create calculated tables. Option C is incorrect because the 'New Table' button under the 'Modeling' tab creates a calculated table using DAX, not Power Query. Option D is incorrect because calculated tables are defined in DAX, not M language. Option E is incorrect because the Fields pane does not have an option to create a calculated table via right-click; calculated tables are created through the Modeling tab or using DAX.

Last reviewed: Jun 11, 2026

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.

Loading comments…

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.