MIN DAX Function in Power BI

In this exercise, we will learn about the MIN dax function in Power BI. The MIN DAX function returns the smallest value in a column, or between two scalar expressions.

DAX Syntax • MIN([column])
• MIN(<expression1>, <expression2>)

The function has the following parameters:
• column: The column in which you want to find the smallest value.
• expression: Any DAX expression which returns a single value.

Example: Let’s we have the following data in the table named Sheet1.

Suppose we want to find the minimum value in the column 12th Marks.

DAX

The output of the above code created the measure which can be shown in the card visual as shown in the image below:

The MIN dax function is subject to the filter context, as shown in image below:

We have selected only Switzerland country, and the 387 is the minimum value in 12thMarks column of the Sheet1 table where the country value is Switzerland.

Example: Find the minimum value from the given expression.

DAX

The output of the above code is 15 as shown in the image below: