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


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 (

Related DAX Functions

Related Course Modules



To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.