MAXA DAX Function in Power BI

The MAXA DAX function returns the largest value in a column.

DAX Syntax MAXA(Table[column])

The parameter column is the column in which we want to find the largest value.

Example: Let’s we have the following table named “Students List”.

MAXA dax function in Power BI

Suppose we want to find the maximum value in column 10th Marks.

DAX

MAXA Measure = MAXA('Students List'[10th Marks])

The output of the above code is shown below:

MAXA dax function in Power BI