FACT Function (DAX)

How does the FACT function (DAX) work?

The FACT function (DAX) returns the factorial of a number, equal to the series 1*2*3* , ending in the given number.

FACT Formula Syntax

FACT(
     <number>
)

How do you use the FACT function?

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.

Related Blog Posts

Related Support Forum Posts

Connect multiple fact-tables – Web Analytics
Creating Lookup Tables From Large Fact Tables
Two Fact Table Model Help

Considerations when using the FACT function

The factorial of the argument in a decimal data type.

Related Video Tutorials

Formula examples using the FACT function

= FACT (
    [Values])

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership