Power Query - Rounds Differently than Excel (DANGER)

Learn the differences between Excel's and Power Query's methods for rounding. See VERY real-world examples that could cost (or save) you thousands of dollars, as well as be the difference in passing or failing a course in school. File Download Link: https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_Rounding.xlsx 00:45 Rounding Differences between Excel and Power Query 02:31 The monetary impact of different rounding methods 03:45 How rounding works in Excel 04:28 Real-world problem that costs (or saves) thousands of dollars 05:42 Make Power Query Round work like Excel 07:15 Have Excel round using Power Query's strategy 07:43 Excel vs. Power Query when grading tests 09:06 Conclusion