Basic arithmetic in DAX in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add two columns in a DAX measure.

Power BI

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

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

A/

B-

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using '-' instead of '+' causes subtraction.

Using '*' or '/' changes the operation to multiplication or division.

The plus sign (+) is used to add two values in DAX.

2fill in blank

medium

Complete the code to calculate the difference between two columns.

Power BI

Difference = SUM(Sales[Revenue]) [1] SUM(Sales[Cost])

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 subtracting.

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

The minus sign (-) subtracts one value from another in DAX.

3fill in blank

hard

Fix the error in the code to multiply two columns correctly.

Power BI

Total Value = SUM(Sales[Quantity]) [1] SUM(Sales[UnitPrice])

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

A*

B-

C/

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' or '-' instead of '*'.

Using '/' causes division, not multiplication.

The asterisk (*) is used for multiplication in DAX.

4fill in blank

hard

Fill both blanks to calculate the average price per unit.

Power BI

Average Price = SUM(Sales[Revenue]) [1] SUM(Sales[Quantity]) [2] 1

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

A/

B*

C+

D-

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '-' changes the calculation.

Using '*' instead of '/' causes wrong results.

First, divide total revenue by quantity using '/'. Then subtract 1 using '-'.

5fill in blank

hard

Fill all three blanks to calculate the profit margin percentage.

Power BI

Profit Margin = (SUM(Sales[Revenue]) [1] SUM(Sales[Cost])) [2] SUM(Sales[Revenue]) [3] 100

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

A-

B/

C*

D+

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '-' changes profit calculation.

Using '*' instead of '/' causes wrong division.

Forgetting to multiply by 100 results in decimal, not percentage.

Subtract cost from revenue with '-'. Divide by revenue with '/'. Multiply by 100 with '*'.