Duration
3 days
Chapter 1: Introduction to DAX
- What Is DAX?
- What Is a Data Model?
- Components of a DAX Data Model
- Data
- Tables
- Columns
- Relationships
- Measures
- Hierarchies
- Your First DAX Calculation
- Your First Calculation
- IntelliSense
- Formatting
- Comments
- Your Second DAX Calculation
- Your Third DAX Calculation
- The CALENDARAUTO Function
- Datatypes
- The Whole Number Datatype
- The Decimal and Fixed Decimal Number Datatype
- Date and DateTime
- Time
- Operators
- Arithmetic Operators
- Comparison Operators
- Concatenation Operator
- Logical Operators
- Operator Precedence
- Relationships
- Types of Relationships
- Hierarchies
Chapter 2: Variables
- Variable Structure
- Using Variables with Text
- Using Variables in Calculated Columns
- Using Variables in Calculated Measures
- Using Variables in Calculated Tables
- Debugging Using Variables
- Nesting Variables
- Nested Variables (Complex)
Chapter 3: Context
- Filter Context
- Implicit Filter Context
- Explicit Filter Context
- Calculated Column
- Calculated Measure
- Hardcoded Example
- Row Context
- Iterators
- How Data Is Stored in DAX
- Column Indexes
- Context Transition
Chapter 4: Summarizing and Aggregating
- The SUMMARIZE Function
- Relationships
- SUMMARIZE with a Filter
- The SUMMARIZECOLUMNS Function
- SUMMARIZECOLUMNS with a Filter
- The GROUP BY Function
- The CURRENTGROUP() Function
- GROUPBY Iterators
- The GROUPBY Double Aggregation
- GROUPBY with a Filter
- Subtotal and Total Lines
- The ISSUBTOTAL Function
Chapter 5: Joins
- Joins in DAX
- Standard Relationship
- How to Join Tables Without a Relationship
- The CROSSJOIN and GENERATE Functions
- CROSSJOIN
- GENERATE
- NATURALINNERJOIN and NATURALLEFTOUTERJOIN
- Lineage
- UNION
- LOOKUPVALUE
Chapter 6: Filtering
- Implicit Filtering
- Explicit Filtering
- The FILTER Function
- Filters and Calculated Tables
Chapter 7: Dates
- Date
- Time
- Date/Calendar Tables
- Automatic Date Tables
- Quick Measures
- Sorting by Columns
- Including the Year When Using Month
- Time Intelligence
- Year to Date
- Period Comparisons
- The Rolling Average
- Rolling Your Own Table
- CALENDAR
- CALENDARAUTO
- Expanding the Date Table
- Adding the Year
- Fiscal Year
- Days from Today
- Weekly Buckets
- Is Working Day
- Weekday Name
- Rolling Your Own—Summary
- Optimizing Dates
Chapter 8: Debugging and Optimizing
- Debugging in DAX
- Debugging Using Columns
- Debugging Using Variables
- Debugging Calculated Measures
- External Tools
- Optimizing
- Optimizing Data Models
Chapter 9: Practical DAX
- Creating a Numbers Table
- Adding a Date Table
- Creating the Sales Table
- Optimizing Sales
- Calculated Columns vs. Calculated Measures
- Calculated Columns
- Calculated Measures
- Show All Sales for the Top Ten Products
- Double Grouping
Programme scope, delivery arrangements and suitability are confirmed during enquiry.