Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Calculated column
Calculated table
Measure
Visual calculation
Checks whether a value is a decimal number, and returns TRUE or FALSE.
Syntax
ISDECIMAL(<value>)
Parameters
| Term | Definition |
|---|---|
value |
The value you want to test. |
Return value
TRUE if the value is a decimal number; 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 functions is an alias of ISCURRENCY.
Example
The following DAX query shows the behavior of ISDECIMAL.
EVALUATE
{
IF ( ISDECIMAL ( 3.1E-1 ), "Is decimal", "Is not decimal" ), // RETURNS: Is not decimal
IF ( ISDECIMAL ( "42" ), "Is decimal", "Is not decimal" ), // RETURNS: Is not decimal
IF ( ISDECIMAL ( 42 ), "Is decimal", "Is not decimal" ), // RETURNS: Is not decimal
IF ( ISDECIMAL ( CURRENCY ( 4.2421 ) ), "Is decimal", "Is not decimal" ) // RETURNS: Is decimal
}