Skip to Main Content
Excel Power Pivot & Power Query For Dummies, 2nd Edition
book

Excel Power Pivot & Power Query For Dummies, 2nd Edition

by Michael Alexander
March 2022
Beginner to intermediate content levelBeginner to intermediate
288 pages
7h 21m
English
For Dummies
Content preview from Excel Power Pivot & Power Query For Dummies, 2nd Edition

Chapter 7

Diving into DAX

IN THIS CHAPTER

check Understanding the fundamentals of the DAX language

check 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.

Ontheweb 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Wayne Winston
Microsoft Excel 365 Bible

Microsoft Excel 365 Bible

Michael Alexander, Dick Kusleika
Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119844488Purchase Link