The VALUE function converts a text string that represents a number to a number.
VALUE(
text
)
- text: Text string that, representing a number, is to be converted into a number, or name of the column that contains the texts to be converted into numbers.
VALUE returns a real number.
If the function is used in a custom column to convert the values of another column, all the texts must be able to be transformed into numbers because, as soon as one text is not convertible, the entire column will be marked with an error.
The text to be converted may represent any number recognizable by the DAX machine: numbers, dates or times. In any other case, the function will return an error.
The following example converts texts that represent different types of numbers:
In the original Excel workbook that contains the read data, data #2 and #3 included a comma as a decimal symbol (due to the Windows regional settings), despite which Power BI has shown it as a period that, when converted in number, it is displayed again with a comma (again, due to the regional settings of the computer). Data #5 received, in the original Excel workbook, a number format with a thousands separator (a format that is ignored when read by Power BI). Data #8 is a time value (15:30).
