Mastering DAX
Free
-
1.Presentation of Mastering DAX 2nd Edition
-
2.Exercises, labs, slides, and demos
-
3.Introduction to DAX
- 3.1 Introduction to DAX
- 3.2 What is DAX?
- 3.3 DAX data types
- 3.4 Calculated columns
- 3.5 Measures
- 3.6 Aggregation functions
- 3.7 Counting values
- 3.8 Conditional functions
- 3.9 Handling errors
- 3.10 Using variables
- 3.11 Mathematical functions
- 3.12 Relational functions
- 3.13 Exercises
- 3.13.1 Average sales per customer
- 3.13.2 Average delivery time
- 3.13.3 Last update of customer
- 3.13.4 Working days
- 3.13.5 Discount categories
- 3.14 Discussion
-
4.Table functions
- 4.1 Table functions
- 4.2 Introduction to table functions
- 4.3 Filtering a table
- 4.4 Ignoring filters
- 4.5 Mixing filters
- 4.6 Distinct
- 4.7 How many values for a column
- 4.8 ALLSELECTED
- 4.9 RELATEDTABLE
- 4.10 Tables and relationships
- 4.11 Tables with one row and one column
- 4.12 Table variables
- 4.13 Exercises
- 4.13.1 Percentage of sales
- 4.13.2 Delivery working days
- 4.13.3 Sales of products in the first week
- 4.13.4 Customers with children
- 4.14 Discussion
-
5.Evaluation contexts
- 5.1 Evaluation contexts
- 5.2 Introduction to evaluation contexts
- 5.3 Filter context
- 5.4 Row context
- 5.5 Context errors
- 5.6 Filtering a table
- 5.7 Using RELATED in a row context
- 5.8 Ranking by price
- 5.9 Evaluation contexts and relationships
- 5.10 Filters and relationships
- 5.11 Exercises
- 5.11.1 Nested iterators
- 5.11.2 Customers in North America
- 5.11.3 Create a parameter table
- 5.12 Discussion
-
6.The CALCULATE function
- 6.1 The CALCULATE function
- 6.2 CALCULATE
- 6.3 CALCULATE examples
- 6.4 CALCULATE recap
- 6.5 What is a filter context?
- 6.6 KEEPFILTERS
- 6.7 CALCULATE operators
- 6.8 Use one column only in compact syntax
- 6.9 Variables and evaluation contexts
- 6.10 Exercises
- 6.10.1 Sales of red and blue products
- 6.10.2 Understanding CALCULATE
- 6.10.3 Sales of blue products
- 6.10.4 Computing percentages
- 6.11 Discussion
-
7.Advanced evaluation contexts
- 7.1 Advanced evaluation contexts
- 7.2 CALCULATE modifiers
- 7.3 USERELATIONSHIP
- 7.4 CROSSFILTER
- 7.5 ALL
- 7.6 ALLSELECTED
- 7.7 KEEPFILTERS
- 7.8 Context transition
- 7.9 Context transition /2
- 7.10 Circular dependency
- 7.11 CALCULATE execution order
- 7.12 Exercises
- 7.12.1 Correct sales of grey products
- 7.12.2 Best customers
- 7.12.3 Customers buying many products
- 7.12.4 Large sales
- 7.12.5 Percentage of customers
- 7.12.6 Counting spikes
- 7.13 Discussion
-
8.Iterators
-
9.Building a date table
-
10.Time intelligence in DAX
- 10.1 Time intelligence in DAX
- 10.2 What is time intelligence?
- 10.3 Time intelligence functions
- 10.4 DATEADD
- 10.5 DATESINPERIOD
- 10.6 Running total
- 10.7 Mixing time intelligence functions
- 10.8 Semi-additive measures
- 10.9 Calculations over weeks
- 10.10 Exercises
- 10.10.1 Running total
- 10.10.2 Comparison YOY%
- 10.10.3 Sales in first three months
- 10.10.4 Semi-additive calculations
- 10.11 Discussion
-
11.Hierarchies in DAX
-
12.Querying with DAX
- 12.1 Querying with DAX
- 12.2 Working with tables and queries
- 12.3 EVALUATE
- 12.4 CALCULATETABLE
- 12.5 SELECTCOLUMNS
- 12.6 SUMMARIZE
- 12.7 SUMMARIZECOLUMNS
- 12.8 CROSSJOIN
- 12.9 TOPN and GENERATE
- 12.10 ROW and DATATABLE
- 12.11 Tables and relationships
- 12.12 UNION, INTERSECT, and EXCEPT
- 12.13 GROUPBY
- 12.14 Query measures
- 12.15 Exercises
- 12.15.1 Sales by year
- 12.15.2 Filtering and grouping sales
- 12.15.3 Using TOPN and GENERATE
- 12.15.4 Sales to top customers
- 12.15.5 Sales of top three colors
- 12.16 Discussion
-
13.Data lineage and TREATAS
-
14.Expanded tables
-
15.Arbitrarily shaped filters
-
16.ALLSELECTED and shadow filter contexts
-
17.Segmentation
-
18.Many-to-many relationships
-
19.Ambiguity and bidirectional filters
-
20.Relationships at different granularities
-
21.Additional exercises
-
22.Calculation groups
- 22.1 Calculation groups
- 22.2 Introducing calculation groups
- 22.3 Basic measures
- 22.4 Calculation items are patterns
- 22.5 Creating calculation groups
- 22.6 Changing the format string
- 22.7 Excluding specific measures
- 22.8 Using calculation items in DAX
- 22.9 Calculation item application
- 22.10 Calculation items on complex expressions
- 22.11 Multiple calculation groups in a report
- 22.12 Understanding precedence in calculation groups
- 22.13 Reusing calculation items
- 22.14 Recursion and best practices
- 22.15 Exercises
- 22.15.1 Time calculations
- 22.15.2 Multiple calculation groups
- 22.15.3 Sold versus delivered
- 22.15.4 Min, Max and Avg calculation group
- 22.15.5 Top and bottom products
- 22.16 Discussion
