Forum Discussion

ckurir's avatar
ckurir
Frequent Visitor
4 years ago
Solved

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...
Need Help
  • jennratten's avatar
    jennratten
    4 years ago

    Hello!  Please try this:

    Number.RoundDown ( 4.8 )

     

     

jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

Hello!  Please try this:

Number.RoundDown ( 4.8 )

 

 

  • ckurir's avatar
    ckurir
    Frequent Visitor
    4 years ago

    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's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      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.