Downloads
DAXInformationBeginner

ISTEXT

Returns TRUE when a value is text.

Syntax
ISTEXT(<value>)

Returns: TRUE or FALSE (a scalar).

What it does

ISTEXT returns TRUE when a value is text and FALSE for numbers, blanks and errors. It is the mirror of ISNUMBER. Use it to find text where numbers are expected, such as an amount column that a spreadsheet user has typed a word into, or to decide whether a value needs VALUE before it can be added.

Syntax and arguments

Example

The accounts payable import has an amount column that should hold numbers. The team wants a flag for any row where the amount is text, so they can fix it before the payment run.

Amount Is Text = ISTEXT(Imports[Amount])

Rows that hold text, such as "N/A" or "TBD", return TRUE. The list of TRUE rows is the correction list for the import team.

Example: a second, different use

Decide whether a column needs conversion before it is used, in a calculated column:

Amount Clean =
IF(
    ISTEXT(Imports[Amount]),
    VALUE(SUBSTITUTE(Imports[Amount], ",", "")),
    Imports[Amount]
)

Text amounts are converted, and numbers pass through unchanged. The IF keeps one column that works for both types.

Things to watch

In business terms

ISTEXT finds the rows in an import that would break a total: a stray note in an amount column, a date typed as text, a number with a currency symbol. Controllers use it as a control before an import is accepted.

Related functions

All DAX functions · View as Markdown · DAX fundamentals