Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Update Label for 'Whole number' data type to 'Integer'

    Vote (28) Share
    zach schultz's profile image

    zach schultz on 15 May 2021 13:40:35

    In Mathematics, the set of whole numbers does not include negatives.

    I suggest the Power BI Team change the name to Integer, to quiet the nagging Mathematicians.

    Source:
    https://www.mathsisfun.com/whole-numbers.html

    Comments (2)
    zach schultz's profile image Profile Picture

    Jason Kohlhoff on 08 Sep 2021 01:01:22

    RE: Update Label for 'Whole number' data type to 'Integer'

    I disagree with the disagreement about Excel's Int() function. That should not be a consideration, because the symantics of functions are defined in the implementation and the associated documentation.  Also, Excel users are not the primary class or cohort of Power BI users.

    The common definition of a whole number is that they cannot be negative.  That is what are children are learning in school.

    zach schultz's profile image Profile Picture

    Ed Hansberry on 16 May 2021 02:58:44

    RE: Update Label for 'Whole number' data type to 'Integer'

    I’m going to disagree here. In Excel the INT() function truncates the number just returning the integer portion. In power query changing to Whole Number rounds. If the term were changed to Integer it would do something different then Excel’s INT() function does.

    I’m not saying it is right, but it is less confusing for excel users.