DAX Function Guide

FIXED
Empty image or helper icon

Sam McKay

CEO & Founder

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

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

Related Blog Posts

Loading

Considerations when using the FIXED?

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

Related Video Tutorials

Loading

Formula examples using the FIXED

=FIXED([PctCost],3,1)

=FIXED(A2, 1)

=FIXED(A3, -1, TRUE)

Related Courses

Loading