Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
eagleae
Frequent 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?

 

eagleae_0-1676366797492.png

 

3 REPLIES 3
eagleae
Frequent Visitor

of course i checked it. there is a decimal 

@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

amitchandak
Super User
Super 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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.