





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










| Dimensions | 18.75 x 3.35 x 22.86 cm |
| Edition | 1st |
| Isbn 10 | 073569835X |
| Isbn 13 | 978-0735698352 |
| Item Weight | 953 g |
| Language | English |
| Print Length | 586 pages |
| Publication Date | 13 Oct. 2015 |
| Publisher | Microsoft Press |
User
Great book - huge depth, will need lots of time to absorb
This book has taught me a huge amount about DAX in a fortnight, but I need to read some chapters again intensively to pick it up fully. The book does warn of this. DAX is probably more like SQL than a OO language, and yet knowing SQL won't get you into the syntax, only the mindset.The stuff towards the back of the book on how DAX models are stored internally, and column based databases, is extremely valuable. Now I realise that I can round some of my numeric data to 3dp to get much faster results. This is totally non-obvious without this background information.
User
Very comprehensive reference to DAX
Very comprehensive reference to DAX. Its cover on time intelligence is very practical and comprehensive. However, I wouldn't recommend this book to DAX beginners, for whom DAXercises by Matt Allington is a better option.
User
Must have book for Power BI professionals
This book is amazing. It gives you full approach to building calculations in DAX and data model optimization. It covers all needed dax expressions in several examples. Full recommendation!
User
Good comprehensive book on DAX.
This is a book that will be useful for many years and will probably take some a few years to fully get their (and my) head around it. The explanations are comprehensive but I think some of the concepts could have been explained a little better. I realise that it is complex but a few diagrams here and there might have helped. Having said that, I think it is a good book which will serve me well long term. Based on this I ordered Analyzing Data with Power BI and Power Pivot and hope the quality is as high as on this one.
User
A title that delivers
The well renowed experts delivers on their promise. I enjoyed reading the content which is well written and in the fewcases where extra examples are needed there is a large blog community on the matter by both the authors and other experts on DAX.
User
The ultimate guide to DAX - no joking
This looks like it *really* IS the definitive guide to DAX. No doubts about it. Very, very thorough. If you are serious about DAX, this IS the way to go.
User
Five Stars
great book, super useful
User
Five Stars
An awesome book to learn DAX, buy it
User
Well worth the time and effort
This is probably the definitive book on DAX, well written the examples are clear and easy to follow, it has helped me learn and better understand DAX and all it's possibilities.
User
EXCELENTE
MATERIAL EXCELENTE.NÃO DIMINUA O TAMANHO DA FONTE. TENHAM MUITO CUIDADO COM FONTE PEQUENA E LIVRO ESPESSO. O DE VOCÊS FICOU LEGAL, EXCELENTE CONHECIMENTO REPASSADO. MAIS TODA VEZ QUE FIZEREM UM LIVRO TENHAM MUITO CUIDADO COM A FONTE. LIVROS MUITO ESPESSOS E ALTURA E LARGURA PEQUENOS FAZEM COM QUE A CAPA DOBRE. EXCELENTE MATERIAL, ACONSELHO QUE COMPREM. PARABÉNS.
User
Uitstekend boek, goed leesbaar
Heel goed boek! De schrijven zijn volgens mij extreem goed bekend met DAX.Het engels is met een beperkte woordenschat geschreven. Dat maakt het prettig om te lezen voor stof die toch al wat denk werk meebrengt.
User
Awesome, Enlightening, Supreme source for DAX
This book is unarguably an authoritative one on DAX. I tried almost all of of the books on DAX in the market. I had finished all of them still couldn't understand how DAX engine works inside. Mostly all of the PowerPivot authors swim around =CALCULATE(SUM(Sales),ProductColor="Red") or =COUNTROWS('Products') etc. Really this duo Alberto & Marco are DAX mavens completely enjoying their supremacy in this BI field.Studying this book is not only enlightening but also you can enjoy the beauty of this language though it is a little tough to understand for an ExcelPro. The way they explain things are very lucid and straight. I've been studying, studying, studying this book for the last 12 months to trying to chew, understand everything about DAX..still miles to go. But one should be very patient when reading this since it is voluminous.This book is not for everyone, that is why you see many negative comments in amazon.com. I highly recommend this book for any aspiring DAX expert. I also recommend other books before you touch this for obvious reasons.
User
難しいが全てを網羅しています
まず、初心者向けではありませんが、非常に良い本だと思います。DAXとその周辺情報を技術的背景からここまで深く理解し、解説したものは恐らくないのではと思わせます(他をすべて読んだわけではないですが)。著者達が運営しているサイトを見ても、そのことが確認できます。内容は、なるべく分かり易く例をあげて説明しようという姿勢はありますが、著者がネイティブではない為か英語が若干単調でメリハリがあまりない感じがします。なので、同じ箇所を何度か繰り返し読まないと頭に入ってこないような印象を持ちました。とはいえ、冒頭の通り、ここまでDAXを網羅したものはないでしょうし(推測です)、DAX辞典と言っても良いでしょう。何度も読み返すことで理解が深まっていきます。
Trustpilot
1 week ago
2 weeks ago