Database Reference
In-Depth Information
ForMAT SPECIFICATIoN
DESCrIPTIoN
"Long Time" or "Medium Time"
Displays a time using your current
culture's long time format; typically
includes hours, minutes, seconds. For
example, 11:07:31 AM.
"Short Time"
Displays a time using your current
culture's short time format. For exam-
ple, 11:07 AM.
STATISTICAL FuNCTIoNS
DAX provides basic statistical functions such as means and counts. These are
listed in Table B-10.
TABle B-10
Statistical Functions
FuNCTIoN
DESCrIPTIoN
AVERAGE(<
column
>)
Returns the average (arithmetic mean)
of all the numbers in a column.
AVERAGEA(<
column
>)
Returns the average (arithmetic mean)
of the values in a column. Handles
text and non-numeric values.
AVERAGEX(<
table
>, <
expression
>)
Calculates the average (arithmetic
mean) of a set of expressions evalu-
ated over a table
COUNT(<
column
>)
The
COUNT
function counts the num-
ber of cells in a column that contain
numbers.
COUNTA(<
column
>)
The
COUNTA
function counts the num-
ber of cells in a column that are not
empty.
COUNTAX(<
table
>, <
expression
>)
The
COUNTAX
function counts non-
blank results when evaluating the
result of an expression over a table.
COUNTBLANK(<
column
>)
Counts the number of blank cells in a
column.
COUNTROWS(<
table
>)
The
COUNTROWS
function counts the
number of rows in the specified
table, or in a table defined by an
expression.