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)