Power Query - Rounds Differently than Excel (DANGER)
ฝัง
- เผยแพร่เมื่อ 19 ก.พ. 2024
- 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:
www.bcti.com//wp-content/YT_D...
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 - วิทยาศาสตร์และเทคโนโลยี
brilliant👍❤
This explains something I couldn't figure out after spending hours trying to find.
So glad it helped. Thanks for watching.
I am more a traditional guy. I like to read the numbers as I learned them in school where we also learned to round. It all depended on the amount of digits if you wanted to round scientifically. In my memory a 5 at the end was also skipped.
At least you now know the way to make it work the way you want in either environment. Thanks for watching.
Perfect explanation, so clear and detailed. Thank you very much.
Thanks for saying such nice words. I appreciate your viewership.
In you cookie example, you didn’t include 25.0 as a possibility. Therefore, of the 10 possibilities each person would get 5 cookies.
Since 0 (zero) is never rounded, it’s not a participant in the rounding game. I realize that the cookie analogy is just that; but it serves to make a larger point. Thanks for watching. Input is always welcomed and appreciated. 👍🏻👍🏻👍🏻
Nice explanation! What the heck setting did you use to make the column letters and row numbers so damn large? My default display is typically half the size (11) by point size as your sample file (22). I couldn't find the setting!
Check out this video I made that explains how to do that.
th-cam.com/video/s50K4g-0kn0/w-d-xo.html
I like to do this so my students can read my projected screen more easily. Thanks for watching!!!
This is awesome. Thank you. Do you know how Dax handles?
If I'm not mistaken, I believe DAX rounding functions behave the same way Excel rounding functions behave. (sorry for the late reply. This one slipped by me.)
Thank you so much.
pls make similar video on salary or wages paid monthly. suppose a person gets salary of 15000 per month and 2 holidays are ignored, what should be his salary in month of February and he has worked only 20 days of that month.?
My real Question is how should we calculate his salary, should we divide it by 28, 30 or 31. to get per day wages.
Let me see what I can come up with.
I'm not an accountant, but if they are salaried (i.e., exempt) employees, wouldn't they get the same pay each month regardless of holidays or actual days worked? If they are hourly (i.e., non-exempt), then I would think they would be paid for the total hours worked per day within the pay period. @@nayanagarwal3260