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.
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 ...
The sample file for this chapter is called