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
<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
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(A3, -1, TRUE)
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.