FACT

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

Math and Trig functions TRUNC function