Int64.From is rounding numbers, not taking just the integer part

[ckurir]

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?

[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".

[jennratten · Accepted solution]

Hello!  Please try this:

Number.RoundDown ( 4.8 )

[ckurir]

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.