# 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