ISINT64
Whether a value is a whole number (as ISINTEGER).
Group: Information. Compatible with DAX.
Syntax
ISINT64 ( <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 of the whole number type (Int64), FALSE otherwise.
Remarks
- The same test as
ISINTEGER: Int64 is the whole number type's name in the model. - Results keep or change type by the usual rules: the sum of a whole number column is whole, its mean is a decimal number, a count of rows is whole.
Examples
Results from a whole number column
EVALUATE
ROW (
"Sum of liters", ISINT64 ( SUM ( Sales[Liters] ) ),
"Mean of liters", ISINT64 ( AVERAGE ( Sales[Liters] ) ),
"Rows", ISINT64 ( COUNTROWS ( Sales ) )
)| Sum of liters | Mean of liters | Rows |
|---|---|---|
| TRUE | FALSE | TRUE |