Table of contents
TOC
Collapse the table of content
Expand the table of content

FACT Function (DAX)

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.

Syntax

FACT(<number>)  

Parameters

TermDefinition
numberThe non-negative number for which you want to calculate the factorial.

Return Value

A decimal number.

Remarks

If the number is not an integer, it is truncated and an error is returned. If the result is too large, an error is returned.

Example

The following formula returns the factorial for the series of integers in the column, [Values].

=FACT([Values])  

The following table shows the expected results:

ValuesResults
01
11
22
36
424
5120
1707.257415615308E+306

See Also

Math and Trig Functions (DAX)
TRUNC Function (DAX)

© 2018 Microsoft