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… 


  1. Could you return the name of the Student with the highest score instead of (or in addition to) to the score itself? I have a similar case: looking for the date with the highest number of transactions.

Leave a Reply

Your email address will not be published.


clear formPost comment