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

14

Complex Patterns

As your DAX skills mature, you’ll inevitably encounter scenarios that go beyond simple aggregations, date intelligence measures, or even some of the more advanced scenarios discussed throughout this book. These complex patterns often arise when real-world business logic doesn’t fit neatly into traditional model structures or when relationships between data elements are indirect, conditional, or intentionally disconnected.

Similar to Chapter 13, Advanced Scenarios, this chapter focuses on identifying, deconstructing, and solving some of the more complex, reoccurring DAX patterns. These patterns include recreating some of the “forgotten” Excel functions that were never given a DAX equivalent. In addition, this chapter includes solving certain problems that were once considered impossible, like the DAX index. Finally, we tackle identifying streaks using DAX as well as aggregating across multiple columns.

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