Edit

Share via

ISNUMERIC

Applies to: Calculated column Calculated table Measure Visual calculation

Checks whether a value is a number, and returns TRUE or FALSE.

Syntax

ISNUMERIC(<value>)

Parameters

Term Definition
value The value you want to test.

Return value

TRUE if the value is numeric; otherwise FALSE.

Remarks

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
  • This function is an alias of ISNUMBER.

Example

The following DAX query shows the behavior of ISNUMERIC.

EVALUATE
{
    IF ( ISNUMERIC ( 0 ), "Is number", "Is Not number" ), // RETURNS: Is number
    IF ( ISNUMERIC ( 3.1E-1 ), "Is number", "Is Not number" ), // RETURNS: Is number
    IF ( ISNUMERIC ( "42" ), "Is number", "Is Not number" ) // RETURNS: Is Not number
}

Related content