VALUE
A number read from text, in the model's culture.
Group: Text. Compatible with DAX.
Syntax
VALUE ( <text> )| Parameter | Type | Description |
|---|---|---|
text | Text | A text that holds a number, a date or a time. |
Returns
Number. The number the text holds, always as a decimal number.
Remarks
- Spaces around the number are fine, and so are a sign and an exponent: " 3 ", "+7" and "1e3" all work.
- A date or a time in the text gives its date number:
VALUE ( "2026-11-02" )is 46328 andVALUE ( "12:00" )is 0.5. - The text is read in the model's culture. In an English (United States) model, the Example Brewery's, "1,234.5" is 1234.5 and "1,5" is 15, as the comma separates thousands; in a Norwegian model "1,5" is 1.5.
- A text that is not a number, empty text included, is an error:
IFERROR ( VALUE ( x ), BLANK () )turns those into blanks. A blank gives BLANK. - A number comes back as it is and a date as its number; TRUE and FALSE are errors.
Examples
Numbers in text
EVALUATE
ROW (
"42", VALUE ( "42" ),
"With spaces", VALUE ( " 3 " ),
"Negative", VALUE ( "-15" ),
"Exponent", VALUE ( "1e3" ),
"Blank", VALUE ( BLANK () )
)| 42 | With spaces | Negative | Exponent | Blank |
|---|---|---|---|---|
| 42 | 3 | -15 | 1000 | (blank) |
Dates and times in text
EVALUATE
ROW ( "Date", VALUE ( "2026-11-02" ), "Noon", VALUE ( "12:00" ) )| Date | Noon |
|---|---|
| 46328 | 0.5 |
Read in the model's culture
English (United States): the comma separates thousands, and the dollar sign and brackets are understood.
EVALUATE
ROW (
"1,234.5", VALUE ( "1,234.5" ),
"1,5", VALUE ( "1,5" ),
"$5", VALUE ( "$5" ),
"(12)", VALUE ( "(12)" )
)| 1,234.5 | 1,5 | $5 | (12) |
|---|---|---|---|
| 1234.5 | 15 | 5 | -12 |