Forum Discussion

eagleae's avatar
eagleae
Frequent Visitor
3 years ago

surplus round up figures

Hi

How to solve problems with rounding up?

In the setting I set up decimals, but when i upload - power bi round 4,68 to 5...

 

Is there one way just to upload from the beginning?

 

 

3 Replies

  • eagleae , Open power Query ( Transform Data -> Transform Data )

     

    and make sure the data type is decimal there. In case it set as whole number in any step, overwrite that step

    • amitchandak's avatar
      amitchandak
      Super User

      eagleae , Share power query steps. If it has been made decimal after it was converted a whole number, that will not work. This means it should be decimal from the first change Type step