DAX Math & Trigonometric - FACT function


Advertisements

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

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements