Buy new:
-12% $43.76
FREE delivery Wednesday, May 22
Ships from: Amazon
Sold by: wisdom tree
$43.76 with 12 percent savings
List Price: $49.99

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
FREE Returns
FREE delivery Wednesday, May 22
Or fastest delivery Friday, May 17. Order within 13 hrs 13 mins
Only 1 left in stock - order soon.
$$43.76 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$43.76
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon
Ships from
Amazon
Sold by
wisdom tree
Sold by
wisdom tree
Returns
30-day easy returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
30-day easy returns
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$9.88
Get Fast, Free Shipping with Amazon Prime FREE Returns
The book may have minor cosmetic wear like creased spine, cover, scratches, curled corners, folded pages, minor sunburn, minor water damage, minor bent. The book may have some highlights, notes, underlined pages. Accessories such as CD, codes, toys, may not be included . Safe and Secure Mailer. No Hassle Return The book may have minor cosmetic wear like creased spine, cover, scratches, curled corners, folded pages, minor sunburn, minor water damage, minor bent. The book may have some highlights, notes, underlined pages. Accessories such as CD, codes, toys, may not be included . Safe and Secure Mailer. No Hassle Return See less
FREE delivery Tuesday, May 21 on orders shipped by Amazon over $35
Or fastest delivery Friday, May 17. Order within 13 hrs 13 mins
Only 1 left in stock - order soon.
$$43.76 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$43.76
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Marco Russo
+ Follow
Alberto Ferrari
+ Follow
See all
Something went wrong. Please try your request again later.

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI 1st Edition

by Alberto Ferrari (Author)
4.7 4.7 out of 5 stars 252 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$43.76","priceAmount":43.76,"currencySymbol":"$","integerValue":"43","decimalSeparator":".","fractionalValue":"76","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"iW4XQsLZKtFB9wRMRM89OcTTuuBdUkoDBX6Spl%2BCcyYtDIQyEri52EhHLoItbXmDuwuaASCWa3rvfrpiLxpK6RD%2FwTU8JERzIn5phk6UvWcMexovrxek%2F12lwNI2T0u3OvZQltQI2WqGNh8Www9wlEisMEWm9mgwYwucA4q%2FQrTvXHNJ3zSr%2BSQHYGLzrKvL","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$9.88","priceAmount":9.88,"currencySymbol":"$","integerValue":"9","decimalSeparator":".","fractionalValue":"88","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"iW4XQsLZKtFB9wRMRM89OcTTuuBdUkoDwxq79p9x7ZHG7U2p0Vmdj8sx4omo9lzpHGQxRdSYDlbJ5EuGIxdwgYgDcEQMmDiVqCDLbJJq1DEq7PTQBk2T%2B7NrOjHj3oH0oUtFLHBFZMugYJlqHL8MeabHlLsFHuBY6TnxHsL6vnGsVTLQlx6sX3ZKBq%2BIFS8l","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

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
Read more Read less
Previous page
  1. ISBN-10
    073569835X
  2. ISBN-13
    978-0735698352
  3. Edition
    1st
  4. Publication date
    October 13, 2015
  5. Language
    English
  6. Dimensions
    7.38 x 1.32 x 9 inches
  7. Print length
    586 pages
  8. See all details
Next page
Books with Buzz
Books with Buzz
Discover the latest buzz-worthy books, from mysteries and romance to humor and nonfiction. Explore more

Frequently bought together

Definitive Guide to DAX, The: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI
$43.76
Get it as soon as Wednesday, May 22
Only 1 left in stock - order soon.
Sold by wisdom tree and ships from Amazon Fulfillment.
+
Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence
$27.99
Get it as soon as Wednesday, May 22
In Stock
Ships from and sold by Amazon.com.
+
Supercharge Power BI: Power BI is Better When You Learn To Write DAX
$24.74
Get it as soon as Tuesday, May 21
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Editorial Reviews

About the Author

Marco Russo and Alberto Ferrari cofounded sqlbi.com, where they regularly publish articles about Microsoft PowerPivot, DAX, Power BI, and SQL Server Analysis Services. They also speak regularly at major international conferences, such as TechEd, Ignite, PASS Summit, and SQLBits. Both consult and mentor on business intelligence (BI) and Microsoft BI technologies, having worked with them since 1999. Their books include Microsoft Excel 2013 Building Data Models with PowerPivot, Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, and Microsoft PowerPivot for Excel 2010: Give Your Data Meaning.

Product details

  • Publisher ‏ : ‎ Microsoft Press; 1st edition (October 13, 2015)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 586 pages
  • ISBN-10 ‏ : ‎ 073569835X
  • ISBN-13 ‏ : ‎ 978-0735698352
  • Item Weight ‏ : ‎ 2.1 pounds
  • Dimensions ‏ : ‎ 7.38 x 1.32 x 9 inches
  • Customer Reviews:
    4.7 4.7 out of 5 stars 252 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Marco Russo

    Marco Russo

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Marco Russo is a business intelligence mentor and consultant in Business Intelligence.

    He founded SQLBI, which provides mentoring and consulting on Business Intelligence based on Microsoft technologies. He has particular competence and experience in sectors like financial services, manufacturing, gambling, and commercial distribution.

    Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification in Microsoft Analysis Services. In addition to his BI-related publications, he has authored books about .NET programming.

    Today, Marco focuses his time on SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide.

    Marco also speaks at international conferences such as Microsoft Fabric, PASS Summit, and SQLBits.

    See more on the author's page
  2. Alberto Ferrari

    Alberto Ferrari

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.

    Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.

    Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.

    Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.

    Outside of SQLBI, most of Alberto's personal time is spent practicing video games, in the vain hope of eventually beating his son.

    See more on the author's page
Next page

Customer reviews

4.7 out of 5 stars
4.7 out of 5
252 global ratings

Top reviews from the United States

Austin K Senseman
5.0 out of 5 stars a DAX book aimed at taking people from intermediate to expert
Reviewed in the United States on November 24, 2015
Verified Purchase
Wow! I make a good part of my living off of Power Pivot and DAX and it's people like Alberto and Marco that have helped me all along the way - with their blog posts, conference sessions, and books. This book really stands out though. It's a very complete treatment of DAX which is the core language of all the "new" analytical tools that Microsoft has released over the past three years.

DAX is a language that, at first glance, looks a lot like Excel and is pretty easy to learn for an advanced Excel user but the language quickly becomes more difficult if you haven't taken the time to understand its foundations - and that's what this book addresses ... in great detail. I've worked full-time with DAX for over three years now and I had lightbulbs going off constantly as I was reading this book. Incredible feeling, thank you.

Said another way, there is knowledge in this book that will be hard to appreciate, that you'll miss entirely, unless you've had lots of experience with DAX. Beginners will get something from the book undoubtedly but it's really a book aimed at taking people from intermediate to expert. I agree with other reviewers who have suggested that DAX beginners start with Albert & Marco's other book "Microsoft Excel 2013 Building Data Models with PowerPivot"
5 people found this helpful
Helpful
 Report
F. Parlamis
5.0 out of 5 stars Very very very good
Reviewed in the United States on May 3, 2020
Verified Purchase
This book is soon going to challenge the Lord of the Rings trilogy for number of total reads. Every time I read it, I learn something new. It not only taught me DAX, it also taught me pivot tables, which I managed not to learn for twenty years as an Excel power user, as well as basic database concepts I also only "kind of" understood. It could probably benefit from some kind of function index, as I often find myself going back to look up information on a function that, for pedagogical reasons, is not all aggregated in one spot. This book has made me a much more efficient and effective Excel user, and the techniques, once absorbed, rapidly pay off the initial time investment in time savings during analysis.
Helpful
 Report
John M. Mcnally
5.0 out of 5 stars Learn from the DAX Masters!!!
Reviewed in the United States on October 19, 2016
Verified Purchase
The Definitive Guide to DAX is the BEST, most in-depth treatment of the DAX language and DAX engine (VertiPaq). It is best suited for someone who already is familiar with the DAX language. Every aspect of the DAX language is introduced in a logical progression, including Evaluation Contexts, Time Intelligence, and Relationships. The insight and low-level details that Marco and Alberto provide are unique to this book.

Later chapters describe the Vertipaq engine, and how to optimize both the data model and DAX queries. There's also plenty of examples on using DAX Studio (this is something I couldn't find in any other books). If you are looking to REALLY learn DAX, then this book is for you. It takes time and effort to get through all of this material, but it is well worth it. Marco and Alberto are the DAX Masters! Their DAX Workshop video is based upon the content in this book, and is excellent. Highly recommended.
6 people found this helpful
Helpful
 Report
cromastro
4.0 out of 5 stars Half of two chapters were missing!
Reviewed in the United States on April 22, 2020
Verified Purchase
I love the book. Learning tons. BUT ... 33 pages are missing from my book. The book abruptly jumps from page 326 to 359. Missing a huge chunk of Advanced Evaluation Contexts and Handling Hierarchies. Whats ... up ... with ... that.
Helpful
 Report
Tamas Polner
5.0 out of 5 stars The best DAX resource, I have been waiting for a long
Reviewed in the United States on November 5, 2015
Verified Purchase
I have been looking forward for this book to be available for shipment. Alberto and Marco's previous books were my 101's into self service BI, but after finishing them, the only resource to go deeper were only available in different online sources. I think this book is definitely a must have for all BI professionals. They are great in explaining even the most difficult concepts, and the material in this book is very much up-to-date with the new Power BI Service and Power BI Desktop. If you are beginner in DAX and BI, it might be too detailed as a starter, the authors even warn you about this, but if you want to become an expert, and want to go down into the details, this is your best resource. If you are a beginner, and especially if you are coming from the business analyst side, start with the other book - Microsoft Excel 2013 Building Data Models with PowerPivot , but buy this one as well, as definitely you will need it.
11 people found this helpful
Helpful
 Report
tahoedenizen
5.0 out of 5 stars In-depth explanations of DAX and the Vertipaq / xVelocity engine
Reviewed in the United States on June 9, 2016
Verified Purchase
This is certainly the definitive guide to the DAX language, which is growing in popularity since it can be used in Excel, Power BI, SQL Server Analysis Services, and other Microsoft tools. DAX is quite easy to use in common cases such as creating a calculated column, but in more advanced cases it offers incredible power, provided you know what you're doing. For users who want to go beyond "recipes" and really understand how DAX works, this book provides clear and thorough explanations of the concepts underlying DAX. Further, it offers great insights into the operation and performance of the Vertipaq / xVelocity engine that processes DAX expressions, enabling you to write queries that run as fast as possible. You have to invest time to get the most out of this book, but if you're using DAX in serious BI applications, the payoff is well worthwhile.
5 people found this helpful
Helpful
 Report
Amazon Customer
5.0 out of 5 stars I cannot recommend this book enough
Reviewed in the United States on December 30, 2016
Verified Purchase
For those who serve in a business intelligence development/analysis context, I cannot recommend this book enough. The title truly fits its content. I work a lot in Microsoft Power BI as a Data Analyst for an energy company and for freelance. This book has provided so much help to me in properly writing DAX formulae...and fixing incorrect formulae. The chapter on evaluation context, though challenging, is certainly the most important aspect of properly understanding and utilizing DAX. Every page of this book is packed with thorough instruction, explanation, and examples. Don't just use this as a reference. Read it left to right so as to gain a good understanding of the breadth and depth of DAX, then continually use it as a reference as you find yourself struggling with various formulaic circumstances.
7 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
raf
5.0 out of 5 stars Great book for DAX and data handling
Reviewed in Canada on February 25, 2019
Verified Purchase
I’m half into the book and I have to say that I am very pleased with it. It explains things very well with very good examples.
One person found this helpful
 Report
Marta
5.0 out of 5 stars Un must
Reviewed in Italy on October 28, 2020
Verified Purchase
Ottimo ottimo libro. Per che vuole conoscere il linguaggio DAX è un must
Report
Weliton
5.0 out of 5 stars EXCELENTE
Reviewed in Brazil on February 17, 2018
Verified Purchase
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.
Report
Arnaud
5.0 out of 5 stars La référence !!!
Reviewed in France on March 5, 2019
Verified Purchase
La bible du language DAX, surtout pour en comprendre les grands concepts.
Plusieurs lectures seront nécessaires. Chaque lecture améliorant le niveau de compréhension. Un seul regret, les variables n’y sont pas traitées et pour cause, elles n’étaient pas disponibles au moment de l’ecriture de ce livre.
J’attends l’edition 2019 avec impatience.
One person found this helpful
 Report
Honestman
5.0 out of 5 stars Awesome, Enlightening, Supreme source for DAX
Reviewed in India on February 26, 2018
Verified Purchase
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.
One person found this helpful
 Report