Blog

Tips, Tutorials, and Stories
Preppin’ Data 2023 Week 10 – With Power Query!

Preppin’ Data 2023 Week 10 – With Power Query!

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

Preppin’ Data 2023 Week 9 – With Power Query!

Preppin’ Data 2023 Week 9 – With Power Query!

This week's challenge had an append with 3 tables, some joins (merges) and some trickiness with a running total by groups! A common thing with PowerQuery is using "Group By" a dimension and then using "All" to generate a nested table in a column. If you are able to...

Bitnami