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

Related Support Forum Posts

Fixed Assets Projection
Fix position for button in a table header
Measure calculating fixed average price per month

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)

Related Course Modules