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
VALUES(Customer[Country]) returns a single-column table of the distinct values in that column, so it satisfies the stem's requirement for a valid calculated-table expression. Entered via New table in Power BI Desktop, it materialises those unique country values as a calculated table.
- ✗
CALCULATE(SUM(Sales[Amount]), ALL(Sales))
Why it's wrong here
CALCULATE returns a scalar value, so it cannot produce a table; calculated tables require DAX table expressions such as SUMMARIZE, ADDCOLUMNS or SELECTCOLUMNS. It is tempting because CALCULATE is a core DAX function, but it belongs inside measures or calculated columns, not as a table definition.
- ✓
FILTER(Products, Products[Color] = "Red")
Why this is correct
FILTER is a table-returning DAX function, so using it in a calculated table definition yields a new table containing only Products rows where Color equals Red. It satisfies the requirement by producing a filtered table at evaluation time.
- ✓
CALENDARAUTO()
Why this is correct
CALENDARAUTO() generates a calculated table by scanning every date column in the model, then building a contiguous date range automatically. This satisfies the stem's requirement for a valid calculated-table creation method, since it returns a table rather than a scalar, and requires no manually specified start or end date.
- ✓
SUMMARIZE(Sales, Sales[ProductID], "Total", SUM(Sales[Amount]))
Why this is correct
SUMMARIZE is a table-returning DAX function, so wrapping it in a calculated table definition produces a new table grouped by ProductID with a Total column. It satisfies the requirement by generating rows at evaluation rather than referencing an existing 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 →
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: Option A is correct because a calculated table in Power BI is created with a DAX table expression, and SUMMARIZE is a valid DAX function that returns a table by grouping data and projecting columns, so a new table can be defined as, for example, NewTable = SUMMARIZE(Sales, Sales[Product], "Total", SUM(Sales[Amount])). Option D is also correct because ADDCOLUMNS is a DAX table function that returns a table with added calculated columns, and it is commonly used inside calculated table expressions such as NewTable = ADDCOLUMNS(VALUES(Product[Category]), "Total Sales", CALCULATE(SUM(Sales[Amount]))). Option B is not correct because Merge Queries in Power Query Editor transforms or combines existing queries and produces a query, not a DAX calculated table. Option C is not correct because Split Column is a Power Query transformation that divides a column's text into multiple columns and does not create a calculated table. Option E is not correct because Group By in a matrix visual is a visual-level aggregation behavior, not a method for creating a calculated table.
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: Option A, DATATABLE(...), is correct because DATATABLE is a DAX table constructor that lets you define a calculated table by specifying column names, data types, and literal row values directly in the expression. Option C, SUMMARIZE(Sales, Product[Color], "Total", SUM(Sales[Amount])), is correct because SUMMARIZE is a DAX function that returns a table grouped by the given columns with aggregated values, and it is commonly used in the formula bar of a calculated table. Option E, CALENDARAUTO(), is correct because CALENDARAUTO is a DAX function that returns a complete date table based on the date range found in the model, and it is a standard way to generate a calculated date table. Option B, CREATE TABLE FROM (SELECT ...), is not valid because that is SQL syntax, not DAX, and Power BI calculated tables are created with DAX table expressions. Option D, TABLE.COLUMNS(), is not valid because it is not a DAX table-returning function and cannot produce a calculated table.
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: Option A is correct because the CALENDAR function is a DAX table-returning function that generates a contiguous date table, and calculated tables are created with DAX table expressions. Option B is correct because DAX table functions such as SUMMARIZE and ADDCOLUMNS return tables and are commonly used in the DAX formula bar to build calculated tables. Option C is incorrect because the 'New Table' button under the Modeling tab expects a DAX table expression, not a Power Query expression. Option D is incorrect because M language in Power Query Editor creates queries/imported tables, not calculated tables. Option E is incorrect because there is no such right-click 'New calculated table' command in the Fields pane.
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.