Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.
Syntax
FACT(<number>)
Parameters
| Term | Definition |
|---|---|
number |
The 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.
-
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
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:
| Values | Results |
|---|---|
| 0 | 1 |
| 1 | 1 |
| 2 | 2 |
| 3 | 6 |
| 4 | 24 |
| 5 | 120 |
| 170 | 7.257415615308E+306 |