Consuming a DAX query in Excel – Unplugged #5

Did you know you can execute a DAX query… in Excel? It is way faster than a PivotTable when it comes to retrieving a large amount of data in a table format.
Let’s see how it works and how to create a query in DAX Studio (just with the Query Builder, no DAX knowledge required!) and then customize the query in Excel so that you enter a parameter… in Excel cells, of course!
Spoiler: Marco is a developer, but he is not that good at VBA.
You are allowed to make jokes about his VBA skills in the comments!