DISCOVER_COMMANDS DMV - Improve Drillthrough and Learn DAX Query

In the past I've demonstrated a few examples of using DAX Query in PowerPivot workbooks, this "create a Date Dim" for example.

The ability to produce tables rather than just pivots can be very useful; not just for ETL-like activities like the above mentioned Date Dim, but also for testing and development; and for producing pivot friendly flattened tables for consumption by other other data vsiualisation toolsets.