SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

FACT Function (DAX)

SQL Server 2008 R2

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

Copy 

FACT(<number>)

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].

Copy 
=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

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.