FIXED 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(number, decimals, no_commas)


number – The number you want to round and convert to text, or a column containing a number.
decimals – (optional) The number of digits to the right of the decimal point; if omitted, 2.
no_commas – (optional) A logical value: if 1, do not display commas in the returned text; if 0 or omitted, display commas in the returned text.

Return Value

A number represented as text.

Reference Data

DAX Functions / Text Functions / FIXED