What Is The Difference Between Max And Maxa Functions In Dax?

1.	What Is The Difference Between Max And Maxa Functions In Dax?
Answer» The MAX FUNCTION takes as an ARGUMENT a column that contains numeric VALUES. If the column contains no numbers, MAX RETURNS a blank. If you want to evaluate values that are not numbers, USE the MAXA function. The MAX function takes as an argument a column that contains numeric values. If the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA function.

Answer»

The MAX FUNCTION takes as an ARGUMENT a column that contains numeric VALUES. If the column contains no numbers, MAX RETURNS a blank. If you want to evaluate values that are not numbers, USE the MAXA function.

The MAX function takes as an argument a column that contains numeric values. If the column contains no numbers, MAX returns a blank. If you want to evaluate values that are not numbers, use the MAXA function.

Discussion

No Comment Found

Related InterviewSolutions

Dax Nested Functions Is Equivalent To Sql What?
What Is The Difference Between Having A Measure As A Second Filter Param And Having The Original Measure Expression As A Param. Filter(table, [measure]) Vs Filter(table, Sum(...))?
Why Don't You Use A Calculate() In The Aggregation Expression Of A Summarizecolumn()?
What Is The Initial Filter Context?
How Does Summarizecolumns Relate To Filtering?
How Can You Propagate Row Context Through Relationships?
How Are Filter Contexts Created?
How Are Row Contexts Created?
What Is The Difference Between Max And Maxa Functions In Dax?
How Does Calculate() Result In Context Transition?

What Is The Difference Between Max And Maxa Functions In Dax?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment