Index

Numbers

1:1 relationships (data models), 2

A

active relationships

ambiguity, 514515

CALCULATETABLE function, 451453

expanded tables and, 450453

USERELATIONSHIP function, 450451

ADDCOLUMNS function, 223224, 366369, 371372

ADDCOLUMNS iterators, 196199

ADDMISSINGITEMS function

authoring queries, 419420, 432433

auto-exists feature (queries), 432433

aggregation functions, xmSQL queries, 625627

aggregations, 568571

in data models, 587588, 647648

SE, 548

VertiPaq aggregations, managing, 604607

aggregators, 42, 43, 44, 4546

AVERAGE function, 4344

AVERAGEX function, 44

COUNT function, 46

COUNTA function, 46

COUNTBLANK function, 46

COUNTROWS function, 46

DISTINCTCOUNT function, 46

DISTINCTCOUNTNOBLANK function, 46

MAX function, ...

Get Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.