Conquering DAX 2019

COURSE CONTENT

MODULE 1: INTRODUCTION TO DAX

• What is DAX?
• DAX data types
• Calculated columns
• Measures
• Aggregation functions
• Counting values
• Conditional functions
• Handling errors
• Using variables
• Mathematical functions
• Relational functions

MODULE 2: TABLE FUNCTIONS

• Introduction to table functions
• Filtering a table
• Ignoring filters
• Mixing filters
• DISTINCT Function
• How many values for a column?
• ALLSELECTED function
• RELATEDTABLE function
• Tables and relationships
• Tables with one row and one column
• Table variables

MODULE 3: EVALUATION CONTEXTS

• Introduction to evaluation contexts
• Filter context
• Row context
• Context errors
• Filtering a table
• Using RELATED in a row context
• Ranking by price
• Evaluation contexts and relationships
• Filters and relationships

MODULE 4: CALCULATE FUNCTION

• Introduction to CALCULATE function
• CALCULATE function examples
• CALCULATE function recap
• What is a filter context?
• KEEPFILTERS function
• CALCULATE operators
• Use one column only in a compact syntax
• Variables and evaluation contexts

 MODULE 5: ADVANCED EVALUATION CONTEXTS

• CALCULATE modifiers
• USERELATIONSHIP function
• CROSSFILTER function
• ALL function
• ALLSELECTED function
• KEEPFILTERS function
• Context transition
• Circular dependency
• CALCULATE execution order

MODULE 6: ITERATORS

• Working with iterators
• MINX and MAXX functions
• Useful iterators
• RANKX function
• ISINSCOPE function

MODULE 7: BUILDING A DATE TABLES

• Introduction to date tables
• Auto Date/Time
• CALENDARAUTO function
• Mark as date table
• Using multiple dates

MODULE 8: TIME INTELLIGENCE IN DAX

• What is time intelligence?
• Time intelligence functions
• DATEADD function
• DATESINPERIOD function
• Running total
• Mixing time intelligence functions
• Semi-additive measures
• Calculation over weeks

MODULE 9: HIERARCHIES IN DAX

• What are hierarchies?
• FILTER and CROSSFILTER function
• Percentages over hierarchies
• Parent-child hierarchies

MODULE 10: DATA LINEAGE AND TREATAS

• What is data lineage?
• TREATAS function

MODULE 11: EXPANDED TABLES

• Filters are tables!
• Difference between base tables and expanded tables
• Filtering a column

MODULE 12: ARBITRARILY SHAPED FILTERS

• What are arbitrarily shaped filters?
• Example of an arbitrarily shaped filter

MODULE 13: ALLSELECTED AND SHADOW FILTER CONTEXTS

• ALLSELECTED function revisited
• Shadow filter contexts

MODULE 14: SEGMENTATION

• Static segmentation
• Circular dependency in calculated tables
• Dynamic segmentation

MODULE 15: MANY-TO-MANY RELATIONSHIPS

• How to handle many-to-many relationships
• Bidirectional filtering
• Expanded table filtering
• Comparison of the different techniques

MODULE 16: AMBIGUITY AND BIDIRECTIONAL FILTERS

• Understanding ambiguity

MODULE 17: RELATIONSHIPS AT DIFFERENT GRANULARITIES

• Working at different granularity
• Using TREATAS function
• Calculated tables to slice dimensions
• Leveraging weak relationships
• Scenario recap
• Checking granularity in the report
• Hiding or reallocating

MODULE 18: QUERYING WITH DAX

• Working with tables and queries
• EVALUATE syntax
• CALCULATETABLE function
• SELECTCOLUMNS function
• SUMMARIZE function
• SUMMARIZECOLUMNS function
• CROSSJOIN function
• TOPN and GENERATE functions
• ROW and DATATABLE functions
• Tables and relationships
• UNION, INTERSECT and EXCEPT functions
• GROUPBY functions
• Query measures