FIXED DAX Function (Text)

Syntax  |  Return values  |  Remarks  

Rounds a number to the specified number of decimals and returns the result as text with optional commas.

Syntax

FIXED ( <Number> [, <Decimals>] [, <NoCommas>] )

Parameter	Attributes	Description
Number		The number you want to round and convert to text.
Decimals	Optional	The number of digits to the right of the decimal point; if omitted, 2.
NoCommas	Optional	A logical value: if TRUE, do not display commas in the returned text; if FALSE or omitted, display commas in the returned text.

Return values

Scalar A single string value.

A number represented as text.

Remarks

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 NoCommas is 0 or is omitted, then the returned text includes commas as usual.

Last update: Nov 21, 2020   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/fixed-function-dax