Downloads
DAXInformationBeginner

ISNUMBER

Returns TRUE when a value is a number.

Syntax
ISNUMBER(<value>)

Returns: TRUE or FALSE (a scalar).

What it does

ISNUMBER tests the data type of a value. It returns TRUE for a number, including zero, and FALSE for text, for a blank and for an error. Use it to check that an amount column really holds numbers before you total it, or to separate a clean row from one that needs a conversion.

Syntax and arguments

Example

A bank import sometimes places notes such as "pending" in the amount column. The reconciliation must count only the rows where the amount is a real number.

Amount Is Number = ISNUMBER(BankLines[Amount])

Rows with a numeric amount return TRUE, and rows with a note return FALSE. A filter on this column gives the list of rows to review before the match runs.

Example: a second, different use

Count the numeric entries in a column of imported balances, to measure how clean the import was:

Numeric Balances =
CALCULATE(
    COUNTROWS(Balances),
    FILTER(
        Balances,
        ISNUMBER(Balances[Amount])
    )
)

The count of numeric rows, compared with the total row count, shows the share of the import that can be used without conversion.

Things to watch

In business terms

ISNUMBER is a data quality test for imported ledgers, bank files and survey results. It finds the rows that will break a total or a comparison, so the team can fix them before the close.

Related functions

All DAX functions · View as Markdown · DAX fundamentals