Forum Discussion
Int64.From is rounding numbers, not taking just the integer part
I have a problem using Int64.From. I just wants the integer part of a number
If I have the number 4.8 it always give me "5", no matter which RoundingMode I use
Int64.From(4.8,null,Roundingmode.Down) = 5
Any idea why and how to work around?
Hello! Please try this:
Number.RoundDown ( 4.8 )
4 Replies
- jennratten
Super User
Hello! Please try this:
Number.RoundDown ( 4.8 )Thanks a lot,
I am relatively new to power query, but in many other programming languages INT means just taking the integer value, not rounding off. I do not understand why power query both have rounding functions and also use INT for rounding.
- AlexisOlson
It is a bit unusual but one difference is that Int64.From can take text as input as well whereas Number.RoundDown("4.8") will throw an error.
- AlexisOlson
The rounding mode only determines how to round numbers like 0.5 that need a tie-breaking rule to round up or down.
This is the "why" and jennratten gives a good "work around".
