There are two things about Power Query and Excel that I want to tell you about in this post. Bill Jelen and I had a chat about these topics, and you can check the full discussion on his YouTube channel (and if you are not a subscriber yet, please consider subscribing and hitting that notification bell while you are there!)
Excel and Power Query‘s default rounding modes
Let‘s say I have a set of numbers that I want to round to two decimal places. What is the rule that you usually use to round decimal numbers? Which law would you apply to round a number that is precisely in the middle between the rounding–up value and the rounding–down value?
I believe that most users will say that:
9.445 rounds to 9.45
9.515 rounds to 9.52.