Index

A

ADDCOLUMNS function
Arithmetic operators

B

Bracket game

C

Calculated column
Calculated measure
fact sale table
fully qualified
SUM function
Calculated table
CALCULATE function
CALENDARAUTO function
Comparison operators
Concatenation operator
Container
Context
defined
filter
SeeFilter context
COUNTROWS function
CROSSJOIN function
CURRENTGROUP() function

D

Data analysis expressions (DAX)
calculated column
calculated measure
calculated table
comments
defined
functions
relationships
SeeRelationships
Data models
ADDCOLUMNS function
adding year
automatic date tables
CALENDAR function
components
columns
data
hierarchies
measures
relationships
tables
defined
date/calendar tables
DateTime fields
Days from Today
fiscal year
FORMAT function
MonthID column
optimizing dates
period comparison calculations ...

Get Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence 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.