Holds 64-bit integers without a fractional part (Int64.Type in Power Query), making it a natural choice for integer keys and counts. Visuals display numbers reliably only as far as 2^53-1.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Whole number in context, with comparison tables and the common traps.
Related terms
- IEEE 754
The floating-point standard used by Power BI's Decimal number type. Because values are stored approximately, comparing for equality, ranking with RANKX or adding up large mixed numbers can behave oddly; Whole number or Fixed decimal number sidestep the problem.
- MONTH
A DAX date function giving a date's month as a whole number, where 1 is January and 12 is December.