https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Rounding-issues/m-p/1480164#M3425 <P>it's not random rounding, you are seeing one of the financial rounding methods.&nbsp;<A href="https://en.wikipedia.org/wiki/Rounding#Round_half_to_even" target="_blank">Rounding - Wikipedia</A></P> <P>&nbsp;</P> <P>if you don't like the result, use one of the many built in rounding functions&nbsp;<A href="https://docs.microsoft.com/en-us/powerquery-m/number-round" target="_blank">Number.Round - PowerQuery M | Microsoft Docs</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 07 Nov 2020 01:40:03 GMT lbendlin 2020-11-07T01:40:03Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Rounding-issues/m-p/1259915#M3292 <P>Hi,</P><P>I have created a simple file with twice the same column to demonstrate the rounding issue I face in Power BI query using the Transform/ Data type: whole number shortcut. You can see that my numbers are randomly rounded up or rounded down. How can I make sure that all number equal or above xyz.5 is rounded up, and any number below xyz.5 is rounded down.</P><P>Thanks!<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rounding issue.JPG" style="width: 941px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/322524i260E61E97CDF2AB0/image-size/large?v=v2&amp;px=999" role="button" title="rounding issue.JPG" alt="rounding issue.JPG" /></span></P> Wed, 29 Jul 2020 17:31:41 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Rounding-issues/m-p/1259915#M3292 Isa01 2020-07-29T17:31:41Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Rounding-issues/m-p/1480164#M3425 <P>it's not random rounding, you are seeing one of the financial rounding methods.&nbsp;<A href="https://en.wikipedia.org/wiki/Rounding#Round_half_to_even" target="_blank">Rounding - Wikipedia</A></P> <P>&nbsp;</P> <P>if you don't like the result, use one of the many built in rounding functions&nbsp;<A href="https://docs.microsoft.com/en-us/powerquery-m/number-round" target="_blank">Number.Round - PowerQuery M | Microsoft Docs</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 07 Nov 2020 01:40:03 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Rounding-issues/m-p/1480164#M3425 lbendlin 2020-11-07T01:40:03Z