DAX Text - VALUE function
Description
Converts a text string that represents a number to a number in numeric data type.
Syntax
VALUE (<text>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
text The text to be converted. |
Return Value
A number.
Remarks
The text parameter for the DAX VALUE function can be a constant, a number, a date, or a time in DAX data types.
If the text is not in one of these following formats, DAX VALUE function returns an error.
If the text represents an integer, the integer is returned.
If the text represents a decimal number with only zero values to the right of the decimal point, then the integer part only is returned.
If the text represents a decimal number, then the decimal number is returned.
Example
= VALUE ("5") returns 5. = VALUE ("5.0") returns 5. = VALUE ("5.1") returns 5.1.