Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

Index

A

ALL and ALLEXCEPT functions

B

Breaking lineage

C

CALCULATE function

context transition

DAX

calculations

Studio

logical plan

profiler trace

result of

running total

SUMX calculation

Calendars

approaches

<year_end_date> value

output

testing

TOTALYTD function

YEAR/YTD

Compositevs . primitive functions

CLOSINGBALANCEMONTH

logical plan

OPENINGBALANCEMONTH

TOTALMTD

types

D

Data modeling

aspects of

filter (see Filter propagation)

Power BI project

relationships

base functions

cumulative month number

cumulative value

edit dialog

home menu

matrix value

one-table solution

quantity ytd

relationships.pbix

table.pbix

time intelligence working

single table

Auto-Exist

DAX statements

measurements

query sent

report

rewritten code

row view

single table

star schema

wrong expectation

snowflake schema

star schema ...