Skip to content

ISCURRENCY

Whether a value is a fixed decimal number (Currency).

Group: Information. Compatible with DAX.

Syntax

ISCURRENCY ( <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

Fixed decimal numbers hold four digits after the decimal point exactly. CURRENCY makes one, and a column of the fixed decimal type holds them.
A decimal number (Double) is not one, even when it is a price such as 2.50; nor is a whole number.
ISDECIMAL is the same test.

Examples

Fixed decimal or not

EVALUATE
ROW (
    "CURRENCY ( 2.5 )", ISCURRENCY ( CURRENCY ( 2.5 ) ),
    "2.5", ISCURRENCY ( 2.5 ),
    "7", ISCURRENCY ( 7 ),
    "CURRENCY ( 2.5 ) + 1", ISCURRENCY ( CURRENCY ( 2.5 ) + 1 )
)

CURRENCY ( 2.5 )	2.5	7	CURRENCY ( 2.5 ) + 1
TRUE	FALSE	FALSE	TRUE

ISDECIMAL, CURRENCY, ISDOUBLE, ISNUMERIC.

Last updated 3 November 2026 · OpenBI Studio 0.3.74