Downloads
DAXTextBeginner

VALUE

Converts a text value that looks like a number into a number.

Syntax
VALUE(<text>)

Returns: A number (a scalar). An error when the text cannot be read as a number.

What it does

VALUE turns text that holds a number into a real number, so it can be added, compared and summed. Imported files often hold amounts as text, which looks right on screen but adds up to nothing. VALUE is the bridge. It works with text that contains only a number, and it depends on the locale for the decimal and thousands symbols.

Syntax and arguments

Example

A bank file stores each amount as text. The reconciliation needs the amounts as numbers to total them against the ledger.

Bank Amount = VALUE(BankLines[AmountText])

A text value of "1234.50" becomes the number 1234.5. Once converted, the column can be summed, and the total can be compared with the ledger total.

Example: a second, different use

Remove the thousands separator first when the text carries one, then convert:

Invoice Total = VALUE(SUBSTITUTE(Invoices[TotalText], ",", ""))

A value of "12,450.00" becomes 12450, which the model can add. This combination is common in bank and marketplace imports.

Things to watch

In business terms

VALUE is the step that makes imported bank, payroll and marketplace data usable. Without it, a total that should match the ledger shows zero, and the reconciliation looks broken when only the data type is wrong.

Related functions

All DAX functions · View as Markdown · DAX fundamentals