Slide 36
Slide 36 text
First Half / A面
MASTERING DAX Video Course 2nd Edition
Introduction DAX
Calculated columns(計算列)、Measures, … ~
Relational functions
1.
Evaluation contexts
Filter context, Row context, …
3.
Advanced evaluation contexts
CALCULATE modifiers, USERELATIONSHIP,
CROSSFILTER,ALL, ALLSELECTED, KEEPFILTERS, …
5.
Building a data table
Auto Date/Time, CALENDARAUTO, Mark as data
table, Using multiple dates
7.
Hierarchies in DAX
階層, FILTER and CROSSFILTER, Percentages over
hierarchies, Parent-child hierarchies
9.
Table functions
Filtering a table, Ignoring filters, Mixing filters, …
2.
The CALCULATE function
CALCULATE, KEEPFILTERS
4.
Iterators
MINX and MAXX, Useful iterators, RANKX,
ISINSCOPE
6.
Time Intelligence in DAX
DATEADD, DATESINPERIOD, Running total, …
8.
Querying with DAX
EVALUATE, CALCULATETABLE, SELECTCOLUMNS,
SUMMARIZECOLUMS, CROSSJOIN, …
10.
参考