The Definitive Guide
to DAX: Business
intelligence with
Microsoft Excel, SQL
Server Analysis Services,
and Power BI
Marco Russo and Alberto Ferrari
PUBLISHED BY
Microsoft Press
A division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2015 by Alberto Ferrari and Marco Russo
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any
means without the written permission of the publisher.
Library of Congress Control Number: 2014955069
ISBN: 978-0-7356-9835-2
Printed and bound in the United States of America.
Fourth Printing: August 2017
Microsoft Press books are available through booksellers and distributors worldwide. If you need support related
to this book, email Microsoft Press Support at mspinput@microsoft.com. Please tell us what you think of this
book at http://aka.ms/tellpress.
This book is provided “as-is” and expresses the author’s views and opinions. The views, opinions and information
expressed in this book, including URL and other Internet website references, may change without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real association or
connection is intended or should be inferred.
Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/
Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of
their respective owners.
Acquisitions Editor: Devon Musgrave
Developmental Editor: Carol Dillingham
Project Editor: Carol Dillingham
Editorial Production: Christian Holdener, S4Carlisle Publishing Services
Technical Reviewer: Gerhard Brueckl and Andrea Benedetti; Technical Review services
provided by Content Master, a member of CM Group, Ltd.
Copyeditor: Leslie Phillips
Indexer: Maureen Johnson, MoJo’s Indexing and Editorial Services
Cover: Twist Creative • Seattle
We dedicate this book to the Picasso team.
This page intentionally left blank