Blog

This week was uh, complicated. Anytime you have to take out Table.Buffer, then you know that it was an advanced query. The challenge involved banking data from two countries, the UK and Ireland. You were tasked with summarizing the data based on reporting days and oh...

So this challenge involved a lot of tricks that were great to practice with Power Query. It involved calculating distances, finding the closest branch for each csutomer, then making a priority list for each branch. First, I set a constant for the conversion from...