Chapter 14. Using DAX as a query language

Throughout this book, you have learned that DAX is a powerful programming language that you can use to write formulas of different complexity and to build simple to complex Business Intelligence (BI) solutions. Chapter 13, provided many examples that you can use in your daily work to build useful reports.

In this chapter, you will learn that DAX is a powerful querying language too. Up to this point in this book, you never worried about querying, mainly because in Microsoft Excel you use the PivotTable tool or the Power View reporting system to build queries. You never needed to create your own queries to build a report. So, what is the point in learning that DAX is a querying language, if you will never ...

Get Microsoft Excel 2013: Building Data Models with PowerPivot now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.