FACT is a DAX function that returns the factorial of a number.
Syntax
FACT( Number )| Argument | Properties | Description |
|---|---|---|
| Number | The nonnegative number you want the factorial of. |
FACT
Updated on
FACT is a DAX function that returns the factorial of a number.
FACT( Number )| Argument | Properties | Description |
|---|---|---|
| Number | The nonnegative number you want the factorial of. |
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.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
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 |
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy