Calculated columns vs measures in Power BI - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated column that adds 10 to the SalesAmount.

Power BI

NewColumn = Sales[SalesAmount] [1] 10

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

A*

B+

C-

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' subtracts instead of adds.

Using '*' or '/' changes the value incorrectly.

The plus sign (+) adds 10 to each SalesAmount value in the calculated column.

2fill in blank

medium

Complete the measure to calculate total sales by summing SalesAmount.

Power BI

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

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

ASalesAmount

BPrice

CDiscount

DQuantity

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Quantity sums units, not sales money.

Choosing Discount or Price does not sum total sales.

The SUM function adds all values in the SalesAmount column to get total sales.

3fill in blank

hard

Fix the error in this calculated column that tries to multiply Quantity by Price.

Power BI

TotalValue = Sales[Quantity] [1] Sales[Price]

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

A-

B+

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' adds values instead of multiplying.

Using '-' or '/' changes the calculation incorrectly.

The asterisk (*) multiplies Quantity by Price to get total value per row.

4fill in blank

hard

Fill both blanks to create a measure that calculates average sales per order.

Power BI

Average Sales = [1](Sales[SalesAmount]) [2] COUNT(Sales[OrderID])

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

ASUM

B/

C*

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVERAGE instead of SUM in numerator changes the calculation.

Using '*' instead of '/' changes the meaning.

This measure sums all sales amounts and divides by the count of orders to find average sales per order.

5fill in blank

hard

Fill all three blanks to create a calculated column that flags high sales over 1000.

Power BI

HighSalesFlag = IF(Sales[SalesAmount] [1] 1000, [2], [3])

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

A>

B1

C0

DSales[SalesAmount]

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' reverses the logic.

Returning SalesAmount instead of 1 or 0 confuses the flag.

This calculated column checks if SalesAmount is greater than 1000. If yes, it returns 1 (flag), else 0.