FIXED

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.


Syntax

FIXED(number, decimals, no_commas)

Parameters

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

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Text Functions / FIXED