Daily DAX : Day 460 ISINTEGER

DAX Function: ISINTEGER

Purpose: Checks if a value is a whole number (integer) → returns TRUE or FALSE

Syntax

ISINTEGER ( <value> )

Parameters

ParameterDescription
<value>The value to test (can be a number, column reference, expression...)

Returns

  • TRUE → value is a whole number (..., -2, -1, 0, 1, 2, 42, ...)
  • FALSE → value has decimal places, is text, blank, etc.
Important: ISINTEGER is just another name for ISINT64.
It checks for whole numbers — not whether the value is numeric in general.
(Use ISNUMBER if you want to check "is this any kind of number?")

Simple Examples

Direct values: 
ISINTEGER( 42 )       → TRUE
ISINTEGER( 0 )        → TRUE
ISINTEGER( -17 )      → TRUE
ISINTEGER( 3.0 )      → TRUE     (3.0 is mathematically an integer)
ISINTEGER( 3.1 )      → FALSE
ISINTEGER( "42" )     → FALSE    (text is not integer)
ISINTEGER( BLANK() )  → FALSE

Realistic Use Cases

  1. Validate user-entered quantities (should be whole numbers) 
    Is Whole Number = 
IF(
    ISINTEGER( Sales[Quantity] ),
    "OK",
    "Error: must be whole number"
)
  2. Conditional formatting or filtering 
    Only Integers = 
CALCULATE(
    SUM( Sales[Amount] ),
    FILTER( Sales, ISINTEGER( Sales[DiscountPercent] ) )
)
  3. Clean data – find rows with decimal values where integer is expected 
    Has Decimals = 
IF( NOT ISINTEGER( [YourColumn] ), "Has decimals!", BLANK() )
  4. Prevent errors in division / modulus operations 
    Safe Division Result = 
IF(
    ISINTEGER( [Divisor] ) && [Divisor] <> 0,
    [Numerator] / [Divisor],
    BLANK()
)

Quick Comparison Table

FunctionChecks for...Returns TRUE for...
ISINTEGERWhole number (integer)42, 0, -5, 3.0
ISNUMBERAny number42, 3.14, -0.001, 5.0
ISBLANKBlank valueBLANK()

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 446 INFO.CSDLMETADATA

Power BI DAX Function: INFO.CSDLMETADATA INFO.CSDLMETADATA` is a specialized DAX function introduced as part of a broader set of "INFO" functions (like `INFO.TABLES` or `INFO.MEASURES`) used for **model introspection**. It allows you to programmatically access the underlying structure of your Power BI semantic model. What does it do? The function returns a table with a single column containing the Conceptual Schema Definition Language (CSDL)  metadata of your model in XML format . In plain English, it exports a highly technical "blueprint" of your entire data model—including tables, columns, relationships, and measures—as a structured XML string. It is essentially the DAX equivalent of the `DISCOVER_CSDL_METADATA` Dynamic Management View (DMV) used in Analysis Services. --- Syntax and Output The syntax is straightforward as it requires no arguments: ```dax EVALUATE INFO.CSDLMETADATA() ``` Return Value : A table with one column and one row. Content : A long string ...
Read more

Daily DAX : Day 453 ENDOFWEEK

Power BI DAX Function: ENDOFWEEK Description The ENDOFWEEK function is a Time Intelligence function in DAX (Data Analysis Expressions) used in Power BI. It returns the date that represents the end of the week containing a specified date (typically Saturday, as weeks are considered to start on Sunday by default in DAX time intelligence). Syntax ENDOFWEEK( [, ]) : A column reference (usually from a Date table) or a date expression. Required. : Optional. Specifies the week-ending convention. Default is Saturday if omitted. Examples 1. Basic usage (default: week ends on Saturday): End of Week = ENDOFWEEK('Date'[Date]) For a date like January 8, 2026 (Thursday), this would return January 10, 2026 (Saturday). 2. In a measure for cumulative sales up to end of week: Total Sales to End of Week = CALCULATE( SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], ST...
Read more