The Definitive Guide to DAX, 2nd Edition

Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel



Bookstore > Books > The Definitive Guide to DAX, 2nd Edition

Price$33.30 - $43.99
Rating
AuthorsMarco Russo, Alberto Ferrari
PublisherMicrosoft Press
Published2019
Pages768
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509306978
ISBN-139781509306978
EBook Hardcover Paperback

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.


  1. (6 books)
  2. (5 books)


5 5 131

Similar Books


The Definitive Guide to Drupal 7

The Definitive Guide to Drupal 7

by Benjamin Melancon, Allie Micka, Amye Scavarda, Benjamin Doherty, Bojhan Somers, Karoly Negyesi, Jacine Rodriguez, Moshe Weitzman, Roy Scholten, Ryan Szrama, Sam Boyer, Jacine Luisi, Stephane Corlosquet, Amanda Miller-Johnson, Dan Hakimzadeh, Kasey Do

The Definitive Guide to Drupal 7 is the most comprehensive book for getting sites done using the powerful and extensible Drupal content management system. Written by a panel of expert authors, the book covers every aspect of Drupal, from planning a successful project all the way up to making a living from designing Drupal sites and to con...

Price:  $6.65  |  Publisher:  Apress  |  Release:  2011

The Definitive Guide to HTML5 WebSocket

The Definitive Guide to HTML5 WebSocket

by Vanessa Wang, Frank Salim, Peter Moskovits

The Definitive Guide to HTML5 WebSocket is the ultimate insider's WebSocket resource. This revolutionary new web technology enables you to harness the power of true real-time connectivity and build responsive, modern web applications.This book contains everything web developers and architects need to know about WebSocket. It discusse...

Price:  $37.99  |  Publisher:  Apress  |  Release:  2013

The Definitive Guide to MongoDB, 3rd Edition

The Definitive Guide to MongoDB, 3rd Edition

by David Hows, Eelco Plugge, Peter Membrey, Tim Hawkins

The Definitive Guide to MongoDB, Third Edition, is updated for MongoDB 3 and includes all of the latest MongoDB features, including the aggregation framework introduced in version 2.2 and hashed indexes in version 2.4. The Third Edition also now includes Node.js along with Python.MongoDB is the most popular of the "Big Data&q...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2015

ActionScript for Flash MX: The Definitive Guide, 2nd Edition

ActionScript for Flash MX: The Definitive Guide, 2nd Edition

by Colin Moock

ActionScript for Flash MX: The Definitive Guide is the most complete, up-to-date reference available for the latest version of ActionScript. Author Colin Moock has added hundreds of new code examples to show new Flash MX techniques in the real world. The book's language reference alone has nearly doubled from the first edition, wit...

Price:  $9.50  |  Publisher:  O'Reilly Media  |  Release:  2002

The Developer's Guide to Social Programming

The Developer's Guide to Social Programming

by Mark D. Hawker

In The Developer's Guide to Social Programming, Mark Hawker shows developers how to build applications that integrate with the major social networking sites. Unlike competitive books that focus on a single social media platform, this book covers all three leading platforms: Facebook, OpenSocial, and Twitter. Hawker identifies the cha...

Price:  $3.74  |  Publisher:  Addison-Wesley  |  Release:  2010

The Definitive Guide to Grails 2

The Definitive Guide to Grails 2

by Jeff Scott Brown, Graeme Rocher

Grails is a full stack framework which aims to greatly simplify the task of building serious web applications for the JVM. The concepts within Grails, like interceptors, tag libs, and Groovy Server Pages (GSP), make those in the Java community feel right at home.Grails' foundation is on solid open source technologies such as Spring, ...

Price:  $35.95  |  Publisher:  Apress  |  Release:  2012

The Definitive Guide to Jakarta Faces in Jakarta EE 10, 2nd Edition

The Definitive Guide to Jakarta Faces in Jakarta EE 10, 2nd Edition

by Bauke Scholtz, Arjan Tijms

Learn and master the new features in the new Eclipse Jakarta Faces (formerly JavaServer Faces or JSF) web framework in this definitive guide written by two of the driving forces of the Faces project and the co-creators of the OmniFaces library. Authors Bauke Scholtz and Arjan Tijms take you through real-world examples that demonstrate how...

Price:  $42.67  |  Publisher:  Apress  |  Release:  2022

Ethernet: The Definitive Guide

Ethernet: The Definitive Guide

by Charles Spurgeon

Ethernet is a core networking technology used by every high tech business. While the basic protocols have changed little, new options such as Fast Ethernet and Gigabit Ethernet have increased the complexity of the topic.Ethernet has been the flavor of choice for networking administrators since the early 1980s because of its ease of use an...

Price:  $3.98  |  Publisher:  O'Reilly Media  |  Release:  2000