Leave Entitlement vs. Usage Analysis in Power Query

Here is a fun and useful way to deploy Power Query to answer questions about leave entitlement vs. usage (or inventory availability vs. consumption)
For example workbook, visit
chandoo.org/wp...

[@chandoo_]

Once again Power Query saves the day... :) Download the sample file from chandoo.org/wp/entitlement-vs-usage-power-query/

[@chaudiep8274]

Instead of showing ''null'', it shows ''Error" and at this step ( 11:33 ), the system doesn't let me input ''Error", it asks me to input a number. What should I do?

[@Me_Suresh]

belated happy birthday to ur kids

[@Planahead-mq8st]

Nice..but workbook download link not working

[@chandoo_]

Can you please try again. The page went live a few minutes after the video is published.

[@xcaliber5592]

Your Audio is terrible. plz save up and buy a descent microphone.

[@chandoo_]

Are you sure? I just heard several minutes of uploaded video and it all sounds fine to me. May be this is a bandwidth / audio quality issue at your end?

[@TheLambPost]

It's not terrible but there is some "popping" sometimes when you emphasize words, that could be improved with a pop filter (take a look on wikipedia for what it is if you don't know). A cheap alternative to a proper pop filter is to cover your mic with a sock, I think that can help.

[@chandoo_]

Thanks for letting me know. I am using a headphone+mic combo rather than a fixed mic. I will try the other mic when explaining longer topics so that I can place pop filter.