The Round menu option in Power Query does not round the same way that Excel rounds. This is a shorter video covering the same information that Excel MVP Celia Alves covered in episode 2391. In order to have Power Query ROUND and Excel ROUND return the same results, you have to edit the formula in Power Query to add RoundingModeAwayFromZero. This video shows you how.