Common Power Query transformations (50+ powerful transformations explained)

We’ve looked at a few Power Query transformations in this series, but now we are going much further. In this post, we look at the simple Power Query transformations available from the main menus. Unfortunately, we can’t cover everything in this post; there are just too many options available. Also, more complex Power Query transformations Read More

Excel rounding vs Power Query rounding: WARNING They are different

The term “rounding difference” commonly describes something insignificant; it rarely raises cause for concern. However, when you discover that Excel rounding and Power Query rounding are different, you suddenly realize that it can be a bigger issue than you first thought. This post explains the different rounding methods in Excel and Power Query, and how Read More