ISDOUBLE
Tells whether a value is of the Double type, the decimal number that most arithmetic gives.
Group: Information. Compatible with DAX.
Syntax
ISDOUBLE ( <value> )| Parameter | Type | Description |
|---|---|---|
value | Value | What is tested: a constant, a column in a row context, a measure or any expression. |
Returns
Boolean. TRUE when the value is a decimal number (the Double type), FALSE otherwise.
Remarks
- Decimal numbers are what most arithmetic gives: a division of whole numbers, a mean, a number written with a decimal point.
- A whole number such as 7 is not a Double, nor is a fixed decimal number made with
CURRENCY. - Text, dates and blanks are FALSE.
Examples
Kinds of numbers
EVALUATE
ROW (
"2.5", ISDOUBLE ( 2.5 ),
"7", ISDOUBLE ( 7 ),
"6 / 3", ISDOUBLE ( 6 / 3 ),
"CURRENCY ( 2.5 )", ISDOUBLE ( CURRENCY ( 2.5 ) )
)| 2.5 | 7 | 6 / 3 | CURRENCY ( 2.5 ) |
|---|---|---|---|
| TRUE | FALSE | TRUE | FALSE |