The following five files contain sample DAX queries and functions from yesterday’s Introduction to DAX session at Boston Code Camp.
- The .DAX query files and the Report Builder report used the Adventure Works sample database. The Power Pivot file uses Wide World Importers.
- Per the slides you might go download DAX Studio for work with the DAX files and your dev/testing generally.
- Be sure to read the comments in the code – some of the queries are intended to fail to explain a point
I believe the combination of several new DAX functions (e.g. NaturalInnerJoin) and variables along with the enhancements to SSRS will make DAX as a query language more and more valuable so I emphasized this with the examples.
In future blogs and possibly for my SSAS 2016 Tabular session at SQL Saturday Providence I may add more detail and supporting examples.
Please let me know if you have any questions or issues with these samples.