VALUE DAX Function (Text)
Converts a text string that represents a number to a number.
Syntax
VALUE ( <Text> )
| Parameter | Attributes | Description |
|---|---|---|
| Text |
The text to be converted. |
Return values
Scalar A single decimal value.
The converted number in decimal data type.
Remarks
The value passed as the text parameter can be in any of the constant, number, date, or time formats recognized by DAX. If text is not in one of these formats, an error is returned.
VALUE is not common because DAX implicitly converts text to numbers as necessary.
Examples
-- VALUE converts a text string that represents a number to a number.
EVALUATE
{
( "INT", 123, VALUE ( "123" ) ),
( "FLOAT", 123.45678, VALUE ( "123.45678" ) ),
( "Scientific (1)", 123e3, VALUE ( "123e3" ) ),
( "Scientific (2)", 123e-3, VALUE ( "123e-3" ) ),
( "Date (1)", DATE ( 2020, 10, 23 ), VALUE ( "2020-10-23" ) ),
( "Date (2)", DATE ( 2020, 10, 23 ), VALUE ( "10/23/2020" ) ),
( "Date (3)", DATE ( 2020, 10, 23 ), VALUE ( "23/10/2020" ) ),
( "Time (1)", TIME ( 10, 23, 45 ), VALUE ( "10:23:45" ) ),
( "Time (2)", TIME ( 18, 05, 00 ), VALUE ( "18:05:00" ) ),
( "Time (3)", TIME ( 18, 05, 00 ), VALUE ( "6:05:00 pm" ) ),
( "Time (4)", TIME ( 18, 05, 00 ), VALUE ( "6:05pm" ) )
}
| Value1 | Value2 | Value3 |
|---|---|---|
| INT | 123 | 123 |
| FLOAT | 123.45678 | 123.45678 |
| Scientific (1) | 123000 | 123000 |
| Scientific (2) | 0.123 | 0.123 |
| Date (1) | 44127 | 44127 |
| Date (2) | 44127 | 44127 |
| Date (3) | 44127 | 44127 |
| Time (1) | 0.4331597222222222 | 0.4331597222222222 |
| Time (2) | 0.7534722222222222 | 0.7534722222222222 |
| Time (3) | 0.7534722222222222 | 0.7534722222222222 |
| Time (4) | 0.7534722222222222 | 0.7534722222222222 |
Last update: Jun 6, 2023 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/value-function-dax
2018-2023 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies