FACT
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 |
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for