नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the largest value in a column.
Syntax
MAXA(<column>)
Parameters
| Term | Definition |
|---|---|
column |
The column in which you want to find the largest value. |
Return value
The largest value.
Remarks
The MAXA function takes as argument a column, and looks for the largest value among the following types of values:
- Numbers
- Dates
Logical values, such as
TRUEandFALSE. Rows that evaluate toTRUEcount as 1; rows that evaluate toFALSEcount as 0 (zero).Empty cells are ignored. If the column contains no values that can be used, MAXA returns 0 (zero).
If you want to compare text values, use the MAX function.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example 1
The following example returns the greatest value from a calculated column, named ResellerMargin, that computes the difference between list price and reseller price.
= MAXA([ResellerMargin])
Example 2
The following example returns the largest value from a column that contains dates and times. Therefore, this formula gets the most recent transaction date.
= MAXA([TransactionDate])