MAX DAX Function in Power BI

The MAX function returns the largest value in a column, or between two scalar expressions.

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

The function has the following parameters:

column: The column in which we want to find the largest 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

MAX Measure = MAX(Sheet1[12th Marks])

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

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

We have selected only Switzerland country, and the 420 is the maximum value in 12th Marks column of the Sheet1 table where the country value is Switzerland.

Example: Find the maximum value from the given expression.

DAX

Max value = MAX(15, 20)

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

Previous Next