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

Summary

This chapter explored several different operational metrics and KPIs. Operational metrics are important because they assist organizations with optimizing internal processes, which can lead to greater efficiency, effectiveness, and profitability as well as aid in customer service. We began with common metrics such as On Time in Full (OTIF) and Order Cycle Time (OCT) which are used throughout supply chains all over the globe. We then explored calculating Delivery Dates in the context of fulfilling backorders. Here we introduced the concept of DAX while loops as well as covered the use of the EARLIER function.

We used the knowledge gained to explore two different methods of calculating Mean Time Between Failure (MTBF) as well as Mean Time To Repair (MTTR) and the Overall Equipment Effectiveness (OEE). We then finished the chapter with a rather simple calculation for Days of Supply as well as an extremely complex metric for Order Fulfillment, which identified the locations from which...

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