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 Querys default rounding modes

Lets 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 roundingup value and the roundingdown value?

I believe that most users will say that:

9.445 rounds to 9.45


9.515 rounds to 9.52.

Why? Most