Table and matrix visuals in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a column to a table visual in Power BI.

Power BI

Table.AddColumn(Source, "NewColumn", each [1])

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

A[Sales] * 1.1

B[Date]

C[Region]

D[Product]

Attempts:

3 left

💡 Hint

Common Mistakes

Using column names without 'each' keyword

Using incorrect syntax for multiplication

To add a calculated column showing 10% more sales, use each [Sales] * 1.1.

2fill in blank

medium

Complete the DAX formula to create a measure that sums the Sales column.

Power BI

Total Sales = [1](Sales[Amount])

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

ACOUNT

BAVERAGE

CSUM

DMAX

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVERAGE instead of SUM

Using COUNT which counts rows, not sums values

The SUM function adds all values in the Sales Amount column.

3fill in blank

hard

Fix the error in the DAX formula to calculate average sales per region.

Power BI

Average Sales = CALCULATE(AVERAGE(Sales[Amount]), [1](Sales[Region]))

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

AFILTER

BVALUES

CALL

DSUMMARIZE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER which requires a table expression

Using ALL which removes filters instead of applying them

The VALUES function returns the distinct regions to calculate average per region.

4fill in blank

hard

Fill both blanks to create a matrix visual grouping sales by Region and Product.

Power BI

MatrixVisual.Rows = [1]
MatrixVisual.Columns = [2]

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

ASales[Region]

BSales[Amount]

CSales[Product]

DSales[Date]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Amount as a grouping field

Using Date instead of Product for columns

Rows should be grouped by Region and columns by Product for the matrix visual.

5fill in blank

hard

Fill all three blanks to create a measure that calculates total sales for the current year.

Power BI

Total Sales CY = CALCULATE([1](Sales[Amount]),
    [2](Sales[Date].[Year], Sales[Date].[Year] = YEAR(TODAY())),
    [3](Sales))

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

ASUM

BFILTER

CALL

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVERAGE instead of SUM

Not using FILTER for the year condition

Not using ALL to clear filters

Use SUM to add sales, FILTER to filter current year, and ALL to remove other filters.