MIN and MAX in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sales amounts for different transactions in a store.

Cell	Value
A1	Sales
A2	150
A3	300
A4	120
A5	450
A6	200

Formula Trace

MIN(A2:A6)

Step 1: Values in A2:A6 = {150, 300, 120, 450, 200}

Step 2: MIN({150, 300, 120, 450, 200})

Cell Reference Map

   A   
1 Sales 
2 150  
3 300  
4 120  
5 450  
6 200  

Formula references cells A2 to A6 for sales values.

The formula MIN(A2:A6) uses the sales values from cells A2 through A6.

Result

   A   
1 Sales 
2 150  
3 300  
4 120  
5 450  
6 200  
7 Min: 120

The minimum sales value 120 is shown in cell A7.

The result of the MIN formula is 120, the smallest sales amount.

Sheet Trace Quiz - 3 Questions

What does the formula MIN(A2:A6) return?

A The largest value in cells A2 to A6

B The sum of values in cells A2 to A6

C The smallest value in cells A2 to A6

D The average of values in cells A2 to A6

Key Result

MIN(range) returns the smallest number in the given range; MAX(range) returns the largest number.