DAX Function Guide

FACT
Empty image or helper icon

Sam McKay

CEO & Founder

How does the FACT 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?

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

Loading

Considerations when using the FACT?

The factorial of the argument in a decimal data type.

Related Video Tutorials

Loading

Formula examples using the FACT

= FACT (
    [Values])

Related Courses

Loading