Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying DAX for Humans
  • Table Of Contents Toc
DAX for Humans

DAX for Humans

By : Greg Deckler
5 (2)
close
close
DAX for Humans

DAX for Humans

5 (2)
By: Greg Deckler

Overview of this book

Although DAX has been around for over a decade, many struggle to master the language primarily because DAX is often taught through the CALCULATE function, which is the most complex and unintuitive function in all of DAX. But what if DAX could be taught without CALCULATE? The result would be an incredibly intuitive and easy way to learn DAX. DAX for Humans stands the traditional approach to learning DAX on its head, foregoing the traditional, legacy methods of learning DAX for a more modern approach that focuses on core DAX concepts and not any specific function. Even if you know nothing about DAX, from the very first chapter you will learn the essentials of the DAX language, as well as a single pattern to solve the majority of DAX problems. From that point forward, you’ll explore how to work with the basic building blocks of the DAX language and apply what you learn to real-world business scenarios across customers, human resources, projects, finance, operations, and more. By the end of this book, you’ll be able to apply your DAX skills to simple, complex, and advanced scenarios; understand how to optimize and debug your DAX code; and even know how to efficiently apply artificial intelligence to help you write and debug your DAX code.
Table of Contents (18 chapters)
close
close
2
Foreword

Multiple Table Functions

DAX includes several interesting functions that have multiple tables as parameters. To investigate these functions, create the following calculated tables, referring to Figure 2.15 for the steps if necessary.

Union Table = UNION( 'Table', 'Table' )

The DAX UNION function appends two tables together. Each table must have the same number of columns.

The DAX EXCEPT function returns all of the rows from the first table parameter that do not appear in the second table parameter. For example, the following formula returns only the rows in the table Table where the Item column does not have a value of “Banana”.

Except Table =
    VAR __Table = FILTER( 'Table', [Item] = "Banana" )
    VAR __Result = EXCEPT( 'Table', __Table )
RETURN
    __Result

The INTERSECT function is the exact opposite of the EXCEPT function and thus the following DAX formula only returns rows where the...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
DAX for Humans
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon