MIN and MAX in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to find the minimum sales amount from the Sales table.

Power BI

MinSales = MIN(Sales[[1]])

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

ADate

BCustomer

CAmount

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a non-numeric column like Date or Customer will cause errors.

Using MAX instead of MIN will give the highest value, not the lowest.

The MIN function returns the smallest value in the specified column. Here, we want the minimum sales amount, so we use Sales[Amount].

2fill in blank

medium

Complete the code to find the maximum order quantity from the Orders table.

Power BI

MaxQuantity = MAX(Orders[[1]])

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

AQuantity

BOrderID

COrderDate

DCustomerName

Attempts:

3 left

💡 Hint

Common Mistakes

Using a date or text column instead of a numeric column.

Confusing MAX with MIN.

The MAX function returns the largest value in the specified column. Here, we want the maximum quantity ordered, so we use Orders[Quantity].

3fill in blank

hard

Fix the error in the code to correctly calculate the minimum discount from the Discounts table.

Power BI

MinDiscount = MIN(Discounts[1])

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

ADiscountAmount

B[DiscountAmount]

C(DiscountAmount)

D{DiscountAmount}

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the square brackets causes syntax errors.

Using parentheses or braces instead of brackets.

In DAX, column names must be enclosed in square brackets inside the table reference. So the correct syntax is Discounts[DiscountAmount].

4fill in blank

hard

Fill both blanks to calculate the maximum and minimum sales amounts from the Sales table.

Power BI

MaxSale = MAX(Sales[[1]])
MinSale = MIN(Sales[[2]])

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

AAmount

BDate

DRegion

Attempts:

3 left

💡 Hint

Common Mistakes

Using different columns for MAX and MIN causes inconsistent results.

Using non-numeric columns like Date or Region.

Both MAX and MIN functions should use the sales amount column Amount to find the highest and lowest sales values.

5fill in blank

hard

Fill all three blanks to create measures for minimum price, maximum price, and average price from the Products table.

Power BI

MinPrice = MIN(Products[[1]])
MaxPrice = MAX(Products[[2]])
AvgPrice = AVERAGE(Products[[3]])

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

APrice

DCost

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing different columns for the calculations.

Using non-numeric columns.

All three measures should use the same numeric column Price to calculate minimum, maximum, and average prices.