Daily DAX : Day 462 ISINT64

DAX ISINT64 Function

ISINT64 checks whether a value is a whole number (integer) that fits in a 64-bit integer format.

It returns:

  • TRUE → value is an integer (no decimal part)
  • FALSE → value has decimal places, is text, blank, date, etc.
Important: ISINT64 is just another name (alias) for ISINTEGER.
Microsoft recommends using ISINTEGER in most cases.

Syntax

ISINT64 ( <value> )
ParameterDescription
<value>The value / expression / column to test

Basic Examples

// Returns TRUE
ISINT64(  42   )  
ISINT64( -17   )  
ISINT64(  0    )  

// Returns FALSE
ISINT64(  3.14 )     // decimal
ISINT64( "123" )     // text
ISINT64( BLANK() )   // blank
ISINT64( TODAY() )   // date

Realistic Use Cases (2025–2026)

  1. Flexible User-Defined Functions (UDFs – Preview feature)
// Modern DAX UDF pattern (very common since 2025)
FUNCTION GetNameOrId =
    ( input ) =>
        IF (
            ISINT64 ( input ),
            LOOKUPVALUE ( Dim[Name], Dim[ID], input ),
            LOOKUPVALUE ( Dim[Name], Dim[Code], input )
        )

This single function accepts both numeric IDs and text codes safely.

  1. Handle mixed / variant input in parameters
VAR CurrencyInput = SELECTEDVALUE ( Parameter[Value] )

RETURN
    IF (
        ISINT64 ( CurrencyInput ),
        CALCULATE ( [Sales], 'Currency'[CurrencyKey] = CurrencyInput ),
        CALCULATE ( [Sales], 'Currency'[Code] = CurrencyInput )
    )
  1. Data validation in calculated columns
ValidInteger = 
    IF ( ISINT64 ( 'RawData'[MaybeNumber] ), "OK", "Has decimals / wrong type" )

Quick Summary Table

Input ValueISINT64 Result
42TRUE
3.0TRUE
3.1FALSE
"45"FALSE
BLANK()FALSE
DATE(2026,1,17)FALSE

January 2026 • ISINT64 = ISINTEGER • Mainly used with modern DAX UDFs and flexible parameters

Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 131 SELECTEDMEASURE

 The SELECTEDMEASURE function in Power BI's DAX (Data Analysis Expressions) language is a powerful tool used primarily within calculation groups to dynamically reference the measure currently being evaluated in a report. It’s part of the calculation group feature introduced to streamline complex reporting scenarios and improve maintainability by reducing the need to duplicate measure logic. What is SELECTEDMEASURE? SELECTEDMEASURE is a DAX function that returns a reference to the measure that is currently active or "selected" in the context of a calculation group. It doesn’t take any arguments and is typically used in the expression of a calculation item within a calculation group. This allows you to write generic logic that can dynamically apply to whichever measure is being evaluated in a visual, without hardcoding specific measure names. Syntax SELECTEDMEASURE()     Returns: A reference to the measure currently being evaluated in the report context. Use Case SELECTEDME...
Read more

Daily DAX : Day 191 MROUND

MROUND DAX Function Syntax: dax MROUND(<number>, <multiple>)     number: The value you want to round.     multiple: The multiple to which you want to round the number. Description: The MROUND function rounds the number to the nearest value that is a multiple of the specified multiple. If the number is exactly halfway between two multiples, it rounds away from zero (e.g., 2.5 to 3 for a multiple of 1). Return Value: A number rounded to the nearest multiple of the specified value. Examples     Basic Rounding:     dax     MROUND(23, 5)         Returns 25, as 25 is the nearest multiple of 5 to 23.     Rounding to Nearest 10:     dax     MROUND(17, 10)         Returns 20, as 20 is the nearest multiple of 10 to 17.     Negative Numbers:     dax     MROUND(-23, 5)         Returns -25, as -25 is the nearest multiple...
Read more

Daily DAX : Day 142 COLLAPSEALL

 The COLLAPSEALL function in Power BI's Data Analysis Expressions (DAX) language is a visual calculation function designed to navigate and manipulate the context of hierarchical data within a visual, such as a matrix or table. Introduced as part of the visual calculations feature in Power BI, it allows users to "collapse" the visual context to the highest level of a specified hierarchy or axis, effectively removing all lower-level details. This function is particularly useful when working with hierarchical data structures (e.g., year > quarter > month) and performing calculations that need to reference aggregated values at the topmost level. Syntax There are two primary forms of the COLLAPSEALL function:     With an Expression (Returns a Value):     COLLAPSEALL(<expression>, <axis>)         <expression>: The calculation or measure you want to evaluate (e.g., [SalesAmount]).         <axis>: The...
Read more