FIXED DAX Function in Power BI
The Fixed DAX function rounds a number to the specified number of decimals and returns the result as text. We can specify that the result be returned with or without commas.
DAX Syntax FIXED(Number, [Decimals], [no_commas])
The function has the following parameters:
- Number: The number we want to round and convert to text, or a column containing a number.
- Decimals: It is an optional parameter. The number of digits to the right of the decimal point; if omitted, 2.
- no_commas: It is an optional parameter. A logical value: if 1, do not display commas in the returned text; if 0 or omitted, display commas in the returned text.
Example: Let’s create a calculated column with name “FIXED column”.
DAX
FIXED column = FIXED('Table Decimals'[Decimals],1)
The output of the above dax code is shown below:
Here, note that the “Decimals” column is a Numeric column, and “FIXED column” is a Text type column.