Blog
Tips, Tutorials, and Stories![Preppin’ Data 2023 Week 9 – With Power Query!](https://www.vizforvets.com/wp-content/uploads/2023/03/PreppinDataYoutubeThumbnail2023Week9-1080x675.jpg)
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...
![Batch Format Excel Queries With VBA](https://www.vizforvets.com/wp-content/uploads/2023/03/ReformatPQCode-1080x675.jpg)
Batch Format Excel Queries With VBA
I realize that there are a lot of tools out there to help you with DAX, Power Query, and all sorts of Excel and Power BI things. I am sure any one of those tools does this more efficiently than what I am about to write about. For folks that are using high end tools...