Cover of The Definitive Guide to DAX

The Definitive Guide to DAX

The Definitive Guide to DAX is a practical reference to the formula language used in Microsoft Power BI, Excel's Power Pivot and SQL Server Analysis Services. Written by two consultants from the SQLBI group, the book starts with the core ideas that shape how DAX calculates results, such as filter context, row context and the difference between calculated columns and measures. It then moves through functions for aggregation, time intelligence and table manipulation, showing how each works in realistic data models. Throughout, the authors explain the reasons behind common errors and performance problems, making the book useful both to newcomers learning the language and to experienced analysts who want a deeper understanding of how the engine evaluates formulas.

Audience
adult
Length
epic · 768 pages

Click a tag to see books like this one that share it. Point at it (on a phone, tap it) for less of it instead.

Read it? Sign in to help tag it.

Liked The Definitive Guide to DAX? Here’s where I’d start.

These suit anyone who liked The Definitive Guide to DAX. Sign in and mark a few books for picks shaped around your own taste.

  1. Photoshop Elements 12: The Missing Manual Shares computer programs
  2. Opening Moves Shares computer programs
  3. Statistics and data analysis in geology Shares computer programs
  4. Basic business statistics Shares computer programs

“If you want more of the same, start with these.”

  1. iPad: The Missing Manual
  2. Arduino For Dummies
  3. C++ programming
  4. Hunting Security Bugs

“If it was the computer programs that hooked you, try one of these.”

  1. An Adobe Illustrator Guide to Type Effects and Logo-Building
  2. Office 2000
  3. Pivot table data crunching for microsoft office excel 2007
  4. Excel 2007 For Dummies Quick Reference

“These start from a similar idea, even if they go somewhere else with it.”

  1. DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX
  2. SQL Cookbook
  3. Elasticsearch: The Definitive Guide: A Distributed Real-Time Search and Analytics Engine
  4. Programming Pig