

Buy anything from 5,000+ international stores. One checkout price. No surprise fees. Join 2M+ shoppers on Desertcart.
Desertcart purchases this item on your behalf and handles shipping, customs, and support to Panama.
This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You’ll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX’s remarkable power and flexibility, this no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI Master core DAX concepts, including calculated columns, measures, and error handling Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions Perform time-based calculations: YTD, MTD, previous year, working days, and more Work with expanded tables, complex functions, and elaborate DAX expressions Perform calculations over hierarchies, including parent/child hierarchies Use DAX to express diverse and unusual relationships Measure DAX query performance with SQL Server Profiler and DAX Studio Review: The bible of DAX - If you want to masters DAX, it’s the perfect book. They explain complicated things very well. Also they give multiple examples. It’s for all the public, from beginners to experts. Review: Takes you from newbie to expert-ish - Amazing book, very well written and organised. I normally prefer watching training videos for learning but this has been far better. Concepts are clearly explained. For me, the biggest thing is that you not only learn how, you also learn why. This is very crucial






























| Best Sellers Rank | 175,888 in Books ( See Top 100 in Books ) 46 in Business & Home Office Spreadsheets 51 in Database Management Systems (Books) |
| Customer Reviews | 4.7 out of 5 stars 1,588 Reviews |
F**Z
The bible of DAX
If you want to masters DAX, it’s the perfect book. They explain complicated things very well. Also they give multiple examples. It’s for all the public, from beginners to experts.
R**S
Takes you from newbie to expert-ish
Amazing book, very well written and organised. I normally prefer watching training videos for learning but this has been far better. Concepts are clearly explained. For me, the biggest thing is that you not only learn how, you also learn why. This is very crucial
A**Z
The DAX Bible
This books doesn't require a lot of comments. It's the DAX Bible. The Definitive Guide to DAX means what it says - it's The Definitive Guide to DAX. You'll find (almost) everything about DAX in this book. It's not a book for fast reading. This book will stay with you for a while. Use this book to read about DAX, to understand DAX, to practice your DAX (using companion content, which includes a demo database), to optimize your data models and DAX. The book is not easy reading, because DAX is not just a list of functions, DAX is based on the fundamental concepts we need to understand. To understand the concepts of DAX you'll need help of an expert. Marco Russo and Alberto Ferrari are the best DAX experts and their consulting time is really expensive. But they put all their knowledge into this book which will cost you less than $40-50. If you're going to work with DAX you must have this book.
K**W
Advanced
This is a clear, well-written book but the title/blurb is somewhat misleading, as I would consider it to be aimed specifically at advanced/heavy users - or people intending to be advanced users - and it spends all its time on DAX and mostly ignores PowerBI itself. There is a fair amount of material on writing code for which a simple PowerBI off-the-shelf measure or trick already exists, for example. A large part of the book is devoted to optimising queries, which assumes your dataset is 5m+ rows. There is a lot of material related to workarounds for some pretty obscure needs. For some reason the authors are obsessed with correctly calculating percentages of subgroups in tables and there are pages and pages on that throughout the book. Perhaps the most frustrating part is that there is one chapter on basically "how to solve real-world problems with DAX" - for example, making sure your year-on-year comparisons are accurate, or honing your year-to-date analysis - but this is very short; I wish it had been the whole book.
R**S
The DAX Bible
I've found this pretty brilliant so far, I've studied through to chapter 6. They say that chapters 4 and 5, on contexts and CALCULATE respectively, are the absolute key ones to nail and the difficulty does ramp up at this point, but apparently once mastered you're well over halfway there. Some chapters necessitate multiple readings, and you'll need to take notes. The style makes the first reading very easy but re-reading for note taking purposes is slightly more long winded as you have to skip through the educational "wrong" bits to keep only the actual correct stuff. I like this balance though because first read of new concepts in DAX can be very dispiriting. I feel that understanding this book cover to cover will make me a genuine DAX guru, and I would recommend it to you if that's your goal also
C**R
Amazon Customer
Great book for anyone interested in DAX or working with DAX. Very useful especially if you have worked with DAX explaining a lot about the engine and all DAX formulas.
D**D
Best complete Dax language guide
Best book for learning Dax thoroughly, later chapters more technical. I started learning with a more beginners book but when I needed deeper explanation and more advanced material this book is all you need. It’s a Dax bible that should be on everyone’s shelf who wants to learn the untracked of the Dax language
N**W
Great book ❤️
It has it all! Everything in detail and very well written! I have been using Power Bi for the past 5 months and needed to understand how the DAX engine works in detail. This book is great for it!
J**O
Descubre todos los secretos de DAX
Un libro ideal para conocer todos los secretos del lenguaje DAX, escrito por dos de sus creadores
C**N
Quel bouquin !!!
Une vraie somme de savoir. Comme le disent les auteurs, il faudra le lire plusieurs fois (et je n'ai pas fini lecture No 1) C'est néanmoins didactique : le livre avance pas à pas (et c'est vrai parfois à grands pas). A mon avis indispensable si on veut comprendre (voire maîtriser) DAX
C**N
Top
Top
A**R
It's Like Having My Own Personal Tutor
This book is brilliant. In very easy to understand language, it takes a deep dive into DAX, explaining the seemingly inexplicable and making sense of complex concepts. This is a book that any-one who plans to write DAX should buy. So as not to mislead you, the book expects you to have a basic understanding of DAX. If you are new to DAX, start off with an introductory book. Soon, you will want to know more and then this is the book for you. Thank-you to the authors for great context and communication.
D**R
Very nice book for data visualization professional
The book where all concepts are covered without compromising content. Every concept has explained with example and screenshot.
Trustpilot
3 days ago
5 days ago