Monthly Archives: February 2016

UK Bank Holidays in Power Query – Easter

In my previous post I showed how to calculate all of the UK Bank Holidays for a nominated year,all holidays except the Easter holidays. In this post we will wrap it up by showing how to calculate those holidays. The … Continue reading

Posted in Excel, Functions, M Code, Power BI, Power Query, UK Bank Holidays | Tagged | 4 Comments

UK Bank Holidays in Power Query

I recently built an application that needed to be able to work out the UK Bank Holidays for any given year. This is relatively easy in Excel, the only two that are a little taxing are Easter Friday and Easter … Continue reading

Posted in Excel, M Code, Power Query, UK Bank Holidays | 2 Comments