Analyzing Data with Power BI and Power Pivot for Excel, First Edition

Index

A

ABC analysis (segmentation), 196–200

active events (duration), 137–146

additive measures

aggregating snapshots, 114–117

fact tables, 51

overview, 225

aggregating

detail tables, 24–30

duration, 129–131

header tables, 24–30

snapshots, 112–117

additive measures, 114–117

semi-additive measures, 114–117

ALL function, 40

allocation factor (granularity), 185–186

ambiguity (relationships), 17–19, 43–45

automatic time dimensions

creating, 58–60

Excel, 58–59

Power BI Desktop, 60

B

bidirectional filtering (cross-filtering)

CROSSFILTER function, 43, 52, 98, 156–157, 159–160, 168, 220

detail tables, 25–29

fact tables, 40–43

granularity, 179–181

header tables, 25–29

many-to-many relationships, 155–157

overview, 218–221

BLANK function, 182

bridge tables ...