Transpose operations in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to transpose a table in Power BI using DAX.

Power BI

TransposedTable = TRANSPOSE([1])

Drag options to blanks, or click blank then click option'

ACALCULATE

BSUMMARIZE

CFILTER

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Using aggregation functions like SUMMARIZE inside TRANSPOSE.

Passing a filter expression instead of a table.

The TRANSPOSE function requires a table as input. Here, SalesData is the table to transpose.

2fill in blank

medium

Complete the code to create a transposed table of selected columns.

Power BI

SelectedColumns = SELECTCOLUMNS(SalesData, "Product", Product, "Amount", Amount)
Transposed = TRANSPOSE([1])

Drag options to blanks, or click blank then click option'

ASelectedColumns

BSalesData

CFILTER(SalesData, Amount > 100)

DSUMMARIZE(SalesData, Product)

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to transpose the original table instead of the selected columns.

Using aggregation functions inside TRANSPOSE.

You must transpose the table with the selected columns, which is SelectedColumns.

3fill in blank

hard

Fix the error in the code to transpose a filtered table.

Power BI

FilteredTable = FILTER(SalesData, Amount > 50)
TransposedTable = TRANSPOSE([1])

Drag options to blanks, or click blank then click option'

AFILTER(SalesData, Amount > 50)

BFilteredTable

CSUMMARIZE(SalesData, Product)

DCALCULATETABLE(SalesData, Amount > 50)

Attempts:

3 left

💡 Hint

Common Mistakes

Passing FILTER function directly inside TRANSPOSE.

Using aggregation functions instead of tables.

TRANSPOSE requires a table variable or table expression. Using the variable FilteredTable is correct.

4fill in blank

hard

Fill both blanks to create a transposed summary table grouped by Product and Year.

Power BI

SummaryTable = SUMMARIZE(SalesData, [1], [2], "TotalSales", SUM(Amount))
TransposedSummary = TRANSPOSE(SummaryTable)

Drag options to blanks, or click blank then click option'

ASalesData[Product]

BSalesData[Year]

CAmount

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Using measure names like Amount as grouping columns.

Using incomplete column references.

SUMMARIZE groups by columns. Use SalesData[Product] and SalesData[Year] as grouping columns.

5fill in blank

hard

Fill all three blanks to create a transposed table with filtered and selected columns.

Power BI

Filtered = FILTER(SalesData, [1] > 100)
Selected = SELECTCOLUMNS(Filtered, "Product", [2], "Amount", [3])
Result = TRANSPOSE(Selected)

Drag options to blanks, or click blank then click option'

AAmount

BSalesData[Product]

CSalesData[Amount]

DProduct

Attempts:

3 left

💡 Hint

Common Mistakes

Using partial column names in SELECTCOLUMNS.

Filtering on wrong column names.

Filter by Amount, select columns with full references SalesData[Product] and SalesData[Amount] before transposing.