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!
Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021...
#unplugged