Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number.




Term Definition
number The non-negative number for which you want to calculate the factorial.

Return value

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

Math and Trig functions
TRUNC function