ISDECIMAL
Whether a value is a fixed decimal number (Currency); the same test as ISCURRENCY.
Group: Information. Compatible with DAX.
Syntax
ISDECIMAL ( <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 fixed decimal number (the Currency type), FALSE otherwise.
Remarks
- Decimal here is DAX's fixed decimal number, the Currency type, not the decimal number type (Double):
ISDECIMAL ( 2.5 )is FALSE. UseISDOUBLEfor those. ISCURRENCYis the same test.
Examples
Fixed decimal against decimal
EVALUATE
ROW (
"ISDECIMAL ( 2.5 )", ISDECIMAL ( 2.5 ),
"ISDECIMAL ( CURRENCY ( 2.5 ) )", ISDECIMAL ( CURRENCY ( 2.5 ) ),
"ISDOUBLE ( 2.5 )", ISDOUBLE ( 2.5 )
)| ISDECIMAL ( 2.5 ) | ISDECIMAL ( CURRENCY ( 2.5 ) ) | ISDOUBLE ( 2.5 ) |
|---|---|---|
| FALSE | TRUE | TRUE |