100,000+ Books, Games & Puzzles in-stock πŸ‡³πŸ‡Ώ

Overnight NZ-wide delivery on in-stock orders πŸš€

The Definitive Guide to DAX

Mastering the semantic model expression language for Microsoft Power BI, Fabric, and Excel
Brief Description
Seasoned experts Alberto Ferrari and Marco Russo help you master DAX for superior business intelligence solutions. The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services,... Read More
Format: Paperback
TEMPORARILY OUT OF STOCK Please add to wishlist to be notified when back in stock

Sorry, we're currently out of stock of The Definitive Guide to DAX. Please add to your Wishlist and we'll send you an email as soon as it's back in stock.

Book Hero Magic formatted this description to make it easier to read. While it's new and still learning, it may not be perfect - your feedback is welcome! Description

Seasoned experts Alberto Ferrari and Marco Russo help you master DAX for superior business intelligence solutions. The Definitive Guide to DAX is an authoritative resource for mastering the DAX language, which is pivotal for creating measures for semantic models in Microsoft Power BI, Fabric, Analysis Services, and Excel. With years of experience since the inception of Power Pivot, the authors offer a comprehensive reference that navigates through the unique and complex concepts of DAX, making it an essential tool for BI professionals.

This third edition updates you with the latest features and provides a framework for writing efficient DAX code, enhancing your ability to customise calculations in data models.

You will gain the skills necessary to understand and apply advanced DAX concepts, structure code in user-defined functions, and leverage new calendars for time intelligence calculations. By reading this book, you will:

  • Understand the foundational concepts of DAX and its unique language structure.
  • Master the use of evaluation contexts to enhance data analysis.
  • Utilise CALCULATE and CALCULATETABLE functions effectively.
  • Implement variables to simplify complex DAX expressions.
  • Leverage classic and new calendar-based time intelligence functions.
  • Work with iterators to perform advanced calculations.
  • Apply visual calculations to improve report interactivity.
  • Create and manage calculation groups for dynamic reporting.
  • Handle complex hierarchies and relationships in data models.
  • Author DAX queries for testing and troubleshooting.

About This Book:

For BI professionals and Excel power users eager to deepen their understanding of DAX and enhance their data modelling capabilities with advanced techniques. Suitable for data analysts and IT specialists seeking to optimise their use of Microsoft Power BI, Fabric, Analysis Services, and Excel for more efficient and insightful data analysis.

Book Details

INFORMATION

ISBN: 9780138244729

Publisher: Ingram Book Company

Format: Paperback

DIMENSIONS

Weight: 250g

Pages: 848

More from Business & Entrepreneurship

View all
  • How To Be Wrong
    Sometimes the only way to be right is to get comfortable with being wrong. Most startup advice is dangerously misguided. The mythology of the lone genius founder, the obsession with capital raising, and the theatre of startup ecosystems lead countless ventures astray. Drawing on two decades at the heart of New Zealand's most successful technology companies – Trade Me, Xero,...
    Paperback
    $3600
    Elsewhere:
    $3999
    (1)
    In Stock
    Ships tomorrow
  • Roadmap to Property Success
    Ready to ditch the 9-to-5 and build lasting wealth through property? In Roadmap to Property Success, seasoned investor and coach Steve Goodey shares the exact strategies that helped him – and thousands of Kiwis – build sustainable property portfolios from scratch. With real-life lessons, hard-won wisdom, and zero sugar-coating, this is your no-BS guide to property investing in New Zealand....
    Paperback
    $3199
    Elsewhere:
    $3999
    In Stock
    Ships tomorrow
  • Shoe Dog
    Shoe Dog by Phil Knight is a riveting memoir that unveils the remarkable journey behind the creation of Nike, one of the world's most iconic and successful brands. Phil Knight's story begins in 1962, when fresh out of business school, he embarks on a daring entrepreneurial adventure with a radical premise: to import high-quality, low-cost athletic shoes from Japan. Armed...
    Paperback
    $2400
    Elsewhere:
    $2899
    (1)
    In Stock
    Ships tomorrow
  • Business Made Simple
    Business Made Simple by Donald Miller is an essential guide for anyone looking to elevate their career and create a profitable business. This practical book offers sixty daily readings, each accompanied by insightful videos, designed to help professionals and business owners gain a clear understanding of how successful businesses operate. Rather than relying on theoretical knowledge, Miller shares actionable strategies...
    Paperback
    $2600
    Elsewhere:
    $3000
    In Stock
    Ships tomorrow
  • The Five Dysfunctions of a Team
    In The Five Dysfunctions of a Team Patrick Lencioni once again offers a leadership fable that is as enthralling and instructive as his first two best-selling books, The Five Temptations of a CEO and The Four Obsessions of an Extraordinary Executive. This time, he turns his keen intellect and storytelling power to the fascinating, complex world of teams. Kathryn Petersen,...
    Hardback
    $4700
    Elsewhere:
    $5199
    (1)
    In Stock
    Ships tomorrow
  • Good To Great
    Good to Great by Jim Collins is an authoritative guide that investigates what takes a company from mere mediocrity to exceptional greatness. This acclaimed work is based on a five-year research project comparing teams that made that leap to those that didn’t. Collins and his research team examined financial performance, management practices, and corporate culture to distill the essential factors...
    Hardback
    $5400
    Elsewhere:
    $6000
    (3)
    In Stock
    Ships tomorrow
  • This Is Strategy
    From Seth Godin, one of the world's most influential business thinkers and bestselling author ofΒ This is Marketing, comes an essential guide to thinking strategically in a complex, ever-changing world."With his signature clarity and brevity, the marketing maven presents memorable, practical advice for making smarter plans." β€”Adam Grant, author of Think AgainIn this unique and thought-provoking book, Godin shares insights on...
    Paperback
    $3150
    Elsewhere:
    $3999
    (1)
    Available
    Ships in 4-6 weeks
  • Zero to One
    Zero to One by Blake Masters and Peter Thiel is a ground-breaking and thought-provoking examination of innovation and what it takes for a new company to prosper. Written by Peter Thiel, the co-founder of one of the most successful tech start-ups in history, this book provides a fresh perspective on how to build a valuable and unique enterprise in a...
    Paperback
    $2500
    Elsewhere:
    $3000
    In Stock
    Ships tomorrow
  • Blue Ocean Strategy, Expanded Edition
    Blue Ocean Strategy, Expanded Edition by W. Chan Kim and RenΓ©e A. Mauborgne is an essential guide for anyone looking to transform their business strategies and leap into untapped market spaces. This acclaimed book illustrates how companies can break free from the traditional war of competition and instead, create their own "blue oceans" of uncontested market space. The authors delve...
    Hardback
    $5700
    Elsewhere:
    $6499
    (1)
    In Stock
    Ships tomorrow
  • The Toyota Way, Second Edition: 14 Management Principles from the World's Greatest Manufacturer
    Explore the enlightened path to transformational business success with the updated and expanded edition of Jeffrey Liker's acclaimed work, The Toyota Way, Second Edition: 14 Management Principles from the World's Greatest Manufacturer. Delve into the legendary business philosophy that has placed Toyota at the pinnacle of global manufacturing excellence. In this highly anticipated update, Jeffrey Liker refines and broadens the...
    Hardback
    $8500
    (1)
    Available
    Ships in 2-3 weeks
  • High Output Management
    High Output Management by Andrew S. Grove is a legendary business book and a Silicon Valley staple. Written by the former chairman and CEO of Intel, it offers invaluable insights into the art of managing and running a successful company. This practical handbook provides guidance for navigating real-life business scenarios and serves as a powerful manifesto that has the potential...
    Paperback
    $3200
    Elsewhere:
    $3700
    In Stock
    Ships tomorrow
  • How to Grow Your Small Business
    The Wall Street Journal Bestseller For so many entrepreneurs, running a small business ended up looking different than they imagined. They’re stressed, discouraged, and not confident in their plan for growth. In How to Grow Your Small Business, Donald Miller gives entrepreneurs a 6-step plan to grow their businesses so they produce dependable, predictable results. Using the exact steps you’ll...
    Paperback
    $2900
    Elsewhere:
    $3500
    In Stock
    Ships tomorrow

Why buy from us?

Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!

Service & Delivery

Service & Delivery

Our warehouse in Auckland holds over 100,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.

Auckland Bookstore

Auckland Bookstore

We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.

Our Gifting Service

Our Gifting Service

Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.