FIXED DAX Function (Text)
Rounds a number to the specified number of decimals and returns the result as text with optional commas.
Syntax
| 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
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: Oct 13, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/fixed-function-dax