FACT Function (DAX)
Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.
FACT(<number>)
Parameters
| Term | Definition |
|---|---|
| number | The non-negative number for which you want to calculate the factorial. |
A decimal number.
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.
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 |
Community Additions
ADD
Show: