DAX Math & Trigonometric - FACT function

Description

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

Syntax

FACT (<number>)

Parameters

Sr.No. Parameter & Description
1

number

The non-negative integer for which you want to calculate the factorial.

Return Value

An integer.

Remarks

  • If the number is not an integer, it is truncated.
  • If the number is negative, an error is returned.
  • If the result is too large, an error is returned.

Example

= FACT (8) returns 40320. 
= FACT (8.6) returns 40320.
dax_functions_mathematical_trigonometric.htm
Advertisements