Chapter 7
Diving into DAX
IN THIS CHAPTER
Understanding the fundamentals of the DAX language
Looking at filter context
This chapter rounds your exploration of Power Pivot with a closer look at the DAX formula language. In Chapter 6, you use a bit of DAX when exploring the mechanics of adding your own calculated columns and calculated measures. Now that you know where DAX expressions fit in your Power Pivot data model, it’s time to take a dive into DAX.
In this chapter, you gain an understanding of the fundamentals of building DAX expressions and explore some commonly used DAX functions that will help you start your DAX journey.
The sample file for this chapter is called Adventure Works.xlsx and can be found on this book's companion website at www.dummies.com/go/excelpowerpivotpowerqueryfd2e. The sample file contains a ready-to-use Power Pivot model with all the data need to follow along in this chapter.
DAX Language Fundamentals
Just like Excel functions, every DAX function outputs a result based on arguments you provide. The difference is that, in Excel, the arguments you use provide cell references such as A2:A10, and in DAX, you use table and column names. For instance, you ...
Get Excel Power Pivot & Power Query For Dummies, 2nd Edition 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.
