Blog
Tips, Tutorials, and StoriesPreppin’ Data 2023 Week 13 – With Power Query
This week I decided to spare everyone a really, really long video and focused on the trickiest part of this week's challenge: dynamically selecting trades and then providing a rolling average. Nested tables with a nested let statement allowed me to dynamically select,...
Preppin Data 2023 Week 12 – With Power Query!
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...