FIXED Function (DAX)

How does the FIXED function (DAX) work?

The FIXED function (DAX) rounds a number to the specified number of decimals and returns the result as text. You can specify that the result be returned with or without commas.

FIXED Formula Syntax

FIXED (
     <number>, <decimals>, <no_commas>
)

How do you use the FIXED function?

The FIXED function can be used to convert its result to text.

Related Blog Posts

 

Considerations when using the FIXED function

If the value used for the decimals parameter is negative, number is rounded to the left of the decimal point.

If you omit decimals, it is assumed to be 2.

If no_commas is 0 or is omitted, then the returned text includes commas as usual.

Related Video Tutorials

Formula examples using the FIXED function

=FIXED([PctCost],3,1)

=FIXED(A2, 1)

=FIXED(A3, -1, TRUE)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI