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.?
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
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!!!
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.)
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.
@@bcti-bctiyes I saw Video on parameters but is it possible to filter at the source so the data that we fetch from Source like SQL or other Databases get filtered based on parameters instead of getting whole data first and than filter.
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. 👍🏻👍🏻👍🏻
brilliant👍❤
This explains something I couldn't figure out after spending hours trying to find.
So glad it helped. Thanks for watching.
Perfect explanation, so clear and detailed. Thank you very much.
Thanks for saying such nice words. I appreciate your viewership.
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
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.
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.
can you guys do videos on M query please?
Is there something specific you are wanting explained? I'm happy to help as best I can.
@@bcti-bctiyes I saw Video on parameters but is it possible to filter at the source so the data that we fetch from Source like SQL or other Databases get filtered based on parameters instead of getting whole data first and than filter.
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. 👍🏻👍🏻👍🏻