Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

ISNUMERIC

Applies to: 👁 Image
Calculated column 👁 Image
Calculated table 👁 Image
Measure 👁 Image
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

Feedback

Was this page helpful?

Additional resources

  • Last updated on