Forum Discussion

non23's avatar
non23
Icon for Helper I rankHelper I
1 year ago
Solved

How to resolve floating numbers in PQ - addition

Hey guys, I'm trying to add two columns to the PQ. Sales: 1012.55 Tax: 101.26 Total:  1113.81 but when I add a custom column for the Total it will show as 1113.80499999999. How can I fix this ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi non23 ,
    Based on your description, it's not clear how your TAX column is formed; if it's said to be derived from a ratio multiplied by sales, it's easy to see why you have so many decimal places. And based on your results, rounding would end in either 8 or 805, it wouldn't round up plus one. So you might try using Number. round() twice.

    = [Sales] + Number.Round(Number.Round([Tax],3),2)

    Final output

     

    Best regards,
    Albert He

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

zenisekd's avatar
zenisekd
Icon for Super User rankSuper User
1 year ago

Just out of curiosity, why does it bother you in Power Query. You do know, you can adjust the decimal places in Power BI on the column format settings? There you can set how the number will be displayed. 

If you round the numbers in Power Query, it might lead to incorrect numbers in the end.