Index

A

ABC (Pareto) classification, 136–143

ABS, mathematical functions, 39–40

absolute differences, 174–175

ADDCOLUMNS

best practices, 250

performance decisions for use, 505–509

use of, 241–244

addition. See also aggregation

DAX operators, 21–22

xmSQL syntax for, 474

ADDMISSINGITEMS, 262–264

aggregation

ADDCOLUMNS and SUMMARIZE, decisions about, 505–509

ADDMISSINGITEMS, 262–264

aggregate functions, 35–37

calculated columns and measures, overview, 22–25

calculated columns and performance, 447–450

calculated tables, use of, 50–51

column cardinality and performance, 442

computing differences over previous periods, 174–175

computing periods from prior periods, 171–174

grouping/joining functions, 250

MDX developers, DAX overview, 14–15

moving annual ...

Get The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial