Forum Discussion
eagleae
3 years agoFrequent Visitor
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
- amitchandakSuper User
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
- eagleaeFrequent Visitor
of course i checked it. there is a decimal
- amitchandakSuper 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