The.Definitive.Guide.to.DAX.pdf

(73888 KB) Pobierz
The Definitive Guide to DAX:
Business intelligence with Microsoft
Power BI, SQL Server Analysis
Services, and Excel
Second Edition
Marco Russo and Alberto Ferrari
Published with the authorization of Microsoft Corporation by:
Pearson Education, Inc.
Copyright © 2020 by Alberto Ferrari and Marco Russo
All rights reserved. This publication is protected by copyright, and permission must be obtained from
the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in
any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For
information regarding permissions, request forms, and the appropriate contacts within the Pearson
Education Global Rights & Permissions Department, please visit
www.pearsoned.com/permissions/.
No patent liability is assumed with respect to the use of the information contained herein. Although
every precaution has been taken in the preparation of this book, the publisher and author assume no
responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use
of the information contained herein.
ISBN-13: 978-1-5093-0697-8
ISBN-10: 1-5093-0697-8
Library of Congress Control Number: 2019930884
ScoutAutomatedPrintCode
Trademarks
Microsoft and the trademarks listed at
http://www.microsoft.com
on the “Trademarks” webpage are
trademarks of the Microsoft group of companies. All other marks are property of their respective
owners.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no
warranty or fitness is implied. The information provided is on an “as is” basis. The authors, the
publisher, and Microsoft Corporation shall have neither liability nor responsibility to any person or
entity with respect to any loss or damages arising from the information contained in this book.
Special Sales
For information about buying this title in bulk quantities, or for special sales opportunities (which
may include electronic versions; custom cover designs; and content particular to your business,
training goals, marketing focus, or branding interests), please contact our corporate sales department
at
corpsales@pearsoned.com
or (800) 382-3419.
For government sales inquiries, please contact
governmentsales@pearsoned.com.
For questions about sales outside the U.S., please contact
intlcs@pearson.com.
EDITOR-IN-CHIEF
Brett Bartow
EXECUTIVE EDITOR
Loretta Yates
DEVELOPMENT EDITOR
Mark Renfrow
MANAGING EDITOR
Sandra Schroeder
SENIOR PROJECT EDITOR
Tonya Simpson
COPY EDITOR
Chuck Hutchinson
INDEXER
Ken Johnson
PROOFREADER
Abigail Manheim
TECHNICAL EDITOR
Daniil Maslyuk
EDITORIAL ASSISTANT
Cindy Teeters
COVER DESIGNER
Twist Creative, Seattle
COMPOSITOR
codeMantra
Contents at a Glance
Foreword
Introduction to the second edition
Introduction to the first edition
CHAPTER 1
What is DAX?
CHAPTER 2
Introducing DAX
CHAPTER 3
Using basic table functions
CHAPTER 4
Understanding evaluation contexts
CHAPTER 5
Understanding
CALCULATE
and
CALCULATETABLE
CHAPTER 6
Variables
CHAPTER 7
Working with iterators and with
CALCULATE
CHAPTER 8
Time intelligence calculations
CHAPTER 9
Calculation groups
CHAPTER 10
Working with the filter context
CHAPTER 11
Handling hierarchies
CHAPTER 12
Working with tables
CHAPTER 13
Authoring queries
CHAPTER 14
Advanced DAX concepts
CHAPTER 15
Advanced relationships
CHAPTER 16
Advanced calculations in DAX
CHAPTER 17
The DAX engines
CHAPTER 18
Optimizing VertiPaq
CHAPTER 19
Analyzing DAX query plans

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin