FACT DAX Function (Math and Trig)
Returns the factorial of a number, equal to 1*2*3*…* Number.
The nonnegative number you want the factorial of.
The factorial of the argument in a decimal data type.
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 largest factorial that can be returned by FACT is 170!
The largest factorial that can be returned by FACT without loss of precision is 21!
This function is not supported in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
-- FACT computes the factorial of a number DEFINE VAR Vals = GENERATESERIES ( 1, 21, 4 ) EVALUATE ADDCOLUMNS ( Vals, "Factorial", FACT ( [Value] ) )
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,
Microsoft documentation: https://docs.microsoft.com/en-us/dax/fact-function-dax