Blog

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...

This week's challenge built on last week's answer. The steps involved using data scaffolding to insert rows for missing dates. The data set had gaps in dates and the trick to completing this challenge was trying to figure out how to do that without duplicating data...