Search  for anything...
Microsoft

The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)

  • Based on 1,251 reviews
Condition: New
Checking for the best price...
$44.41 Why this price?
Save $15.58 was $59.99

Buy Now, Pay Later

As low as $11 / mo
  • – 4-month term
  • – No impact on credit to apply
  • – Instant approval decision
  • – Secure and straightforward checkout

Ready to go? Add this product to your cart and select a plan during checkout.

Payment plans are offered through our trusted finance partners Klarna, Affirm, Afterpay, Zip, Apple Pay, and Google Pay. No-credit-needed leasing options through Acima may also be available at checkout.

Learn more about financing & leasing here.

Selected Option

Free shipping on this product

FREE 30-day refund/replacement

To qualify for a full refund, items must be returned in their original, unused condition. If an item is returned in a used, damaged, or materially different state, you may be granted a partial refund.

To initiate a return, please visit our Returns Center.

View our full returns policy here.

Availability: Only 9 left in stock, order soon!
Fulfilled by Amazon
Arrives Wednesday, Aug 19
Order within 9 hours and 43 minutes
Available payment plans shown during checkout
Protection Plan Protect Your Purchase
Checking for protection plans...

Recently Viewed

Format: Paperback


Description

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft’s DAX language for business intelligence, data modeling, and analytics. Expert 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, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX’s remarkable capabilities? This no-compromise “deep dive” is exactly what you need. Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel· Master core DAX concepts, including calculated columns, measures, and calculation groups· Work efficiently with basic and advanced table functions· Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions· Perform time-based calculations· Use calculation groups and calculation items· Use syntax of variables (VAR) to write more readable, maintainable code· Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters· Master advanced optimization techniques, and improve performance in aggregations· Optimize data models to achieve better compression· Measure DAX query performance with DAX Studio and learn how to optimize your DAX Read more

Publisher ‏ : ‎ Microsoft Press


Publication date ‏ : ‎ July 2, 2019


Edition ‏ : ‎ 2nd


Language ‏ : ‎ English


Print length ‏ : ‎ 768 pages


ISBN-10 ‏ : ‎ 1509306978


ISBN-13 ‏ : ‎ 78


Item Weight ‏ : ‎ 2.77 pounds


Dimensions ‏ : ‎ 7.38 x 1.52 x 9.13 inches


Part of series ‏ : ‎ Business Skills


Frequently asked questions

If you place your order now, the estimated arrival date for this product is: Wednesday, Aug 19

Yes, absolutely! You may return this product for a full refund within 30 days of receiving it.

To initiate a return, please visit our Returns Center.

View our full returns policy here.

  • Klarna Financing
  • Affirm Pay in 4
  • Affirm Financing
  • Afterpay Financing
  • Zip Pay in 4
  • Financing through Apple Pay
  • Financing through Google Pay
Leasing options through Acima may also be available during checkout.

Learn more about financing & leasing here.

Top Amazon Reviews

    • Love the content. Love the style. This is within arms reach any time I am working with DAX.
Format: Paperback
Looked into this because it was recommended by Maven Analytics whose training vids are awesome. I love this book. Great for learning and for a reference tool. I appreciate that they really stress learning the underlying concepts/theory instead of just giving cookie cutter patterns to use.
Reviewed in the United States on November 11, 2025 by DMann
    • Amazing Book
Format: Paperback
I have been reading this book for 5 months. I am not finished. I spend a half hour every day. Marco Russo and Alberto Ferrari are teachers and very good ones. There is so much effort put into this book it feels like they actually care about you and your DAX journey. I have gotten so much out of this book. Though I can't say that I truly understand it. Yet I see that my DAX has improved quite a bit. With many mysteries still remaining. I am just an average person trying to be a bit above average and I thank the authors for helping me in my quest. I highly recommend this book. Though if I were starting off from scratch I would read Matt Allington's book Supercharge Power BI and possibly Power Pivot and Power BI by Rob Collie and Avichal Singh though that book is a bit older. In summation: my lack of understanding is my issue, the book itself is extremely comprehensive and well written. So I will continue on my DAX journey and hopefully will continue to improve as I make my way through the final 3rd of the book. ... show more
Reviewed in the United States on May 19, 2020 by Robert Wolf
    • Excellent Resource!
Format: Paperback
I love this book! The authors know their audience. It's written in such a way that the reader feels as though they're being taught by instructors. They give helpful learning tips along the way and know when a certain topic is especially difficult. For example, at the end of a certain arduous chapter, the conclusion starts, "In this final section of a long and difficult chapter..." Upon completion, it is easy to go back and use as a guide for specific topics as they arise. ... show more
Reviewed in the United States on August 17, 2021 by Sarah Elrays
    • Damaged binding Damaged binding
Format: Paperback
Review Image by Amazon Customer
Great book content-wise, but I bought it new and the binding is damaged, corners are bent, and some pages are creased. Should have just purchased a used copy.
Reviewed in the United States on October 8, 2023 Reviewed in the United States on October 8, 2023 by Amazon Customer
    • Now I really know what's happening under the hood
Format: Kindle
This was a really important book for my understanding of Dax formulas. I watched a lot of videos online, and forums can often give you formulas that will solve your problem but I never fully understood what was happening. I feel very confident now after reading this book. I can visualize what is happening with my model and it has made writing Dax much easier. I'm not saying that I'm an expert or that it's easy now, but I know how it works and the functions that are available to me. If you really want to know what's happening, this is the book for you. ... show more
Reviewed in the United States on December 11, 2019 by S. Bellomo
    • Excellent Book
Format: Paperback
This book is really helpful in breaking down the complexity of each function into clear explanations & examples. Thank you so much for the authors. I'm really happy with my purchase
Reviewed in the United States on May 22, 2024 by Ammar S.
    • The most holy text of the DAX religion...
Format: Paperback
Reading this book makes me realize how little I know about the things I thought I knew. I've been writing DAX for years, having started with PowerPivot (no spaces in the name, that's how old) for Excel 2010, and in my job I still find new, interesting problems to solve. This book is an amazing reference for anyone interested in pushing the calculation envelope in DAX and their models. I've built models spanning billions of records with the expert guidance this book provides. I would almost consider this a holy book of the DAX religion. If you ever wanted someone to explain why god created CALCULATE() and how we should observe it daily in our lives, this is the book, and the Italians preach adeptly. I'm a big believer, and you will be too. ... show more
Reviewed in the United States on June 2, 2020 by Anonymous
    • A Must Reference for any DAX library
Format: Paperback
Highly recommended to anyone working with DAX in Excel or PowerBI. From the top DAX trainers in world, this is a must have in your DAX library. Well Written. Easy to follow. Examples are thorough.
Reviewed in the United States on September 11, 2019 by Frances Reed

Can't find a product?

Find it on Amazon first, then paste the link below.
Checking for best price...