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