Skip to main content

    Power BI

    Completed

    DAX function ISWHOLENUMBER

    Vote (2) Share
    Matthew Farrow's profile image

    Matthew Farrow on 17 Jul 2018 16:58:31

    A function in DAX for ISWHOLENUMBER may be a good way to identify leap years in date ranges among other tasks.

    Administrator on 09 Dec 2020 01:04:41

    You can do this with [Number]=INT([Number])

    Comments (1)
    Matthew Farrow's profile image Profile Picture

    Kenneth Barber on 06 Jul 2020 00:00:46

    RE: DAX function ISWHOLENUMBER

    ISWHOLENUMBER([Number])
    would be the same as
    [Number]=INT([Number])

    If such a function were introduced, it should be called ISINTEGER so that it includes negative numbers.