DAX function
VALUE — DAX function reference
Text to number.
Syntax
dax
VALUE(<text>)
Examples
dax
VALUE([CodeText])
→ A number
dax
SUMX(Sales, VALUE(Sales[QuantityText]) * Sales[UnitPrice])
→ Converts a text-typed source column to a number before multiplying
dax
IFERROR(VALUE(Product[SKU_Numeric_Part]), BLANK())
→ Safely converts, returning blank instead of an error for non-numeric SKUs
Common mistakes & gotchas
- VALUE respects the model’s locale for decimal and thousands separators (e.g., "1.234,56" vs "1,234.56") — a text column imported from a different locale can silently convert to the wrong number if the model’s locale doesn’t match the source format.
- It errors on genuinely non-numeric text with no fallback, so wrap it in IFERROR (or better, fix the conversion at the data-source level) when the column isn't guaranteed to be clean.
Related DAX functions
From Text