FACT DAX Function (Math and Trig)

Syntax  |  Return values  |  Examples  

Returns the factorial of a number, equal to 1*2*3*…* Number.

Syntax

FACT ( <Number> )

Parameter	Attributes	Description
Number		The nonnegative number you want the factorial of.

Return values

Scalar A single decimal value.

The factorial of the argument in a decimal data type.

Examples

--  FACT computes the factorial of a number
DEFINE 
    VAR Vals = GENERATESERIES ( 1, 21, 4 )
EVALUATE
ADDCOLUMNS ( 
    Vals,
    "Factorial",  FACT ( [Value] )
)

Value	Factorial
1	1
5	120
9	362,880
13	6,227,020,800
17	355,687,428,096,000
21	51,090,942,171,709,440,000

Last update: Jul 24, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation: https://docs.microsoft.com/en-us/dax/fact-function-dax