MIN, MAX – highest and smallest values in range (DAX – Power Pivot and Power BI)

This article is about simple functions MIN and MAX (that are working in Excel very similarly).

We will use this table with student´s scores.

When looking for the highest value, we can use MAX function:

• highest value = max(Students[Test score])

When looking for the smallest value, we can use the MIN function.

• smallest value = MIN(Students[Test score])

Then we can see the result in some of the visuals…