Beskrivning

Module 1: Introduction to DAX
• Purpose of DAX in Power BI, Power Pivot, and SSAS Tabular models.
• Basic syntax and formula structure (functions, operators, expressions).
• Calculated columns vs. measures vs. calculated tables.
• Introduction to data types and type handling in DAX.
• Importance of data model in DAX logic.

Module 2: DAX Row Context
• Definition of row context and when it applies.
• How row context is created in calculated columns.
• Iterators (e.g., SUMX, FILTER, AVERAGEX) and their relation to row context.
• Common pitfalls (e.g., why SUM(Table[Column]) behaves differently from
SUMX).
• Row context in nested functions.

Module 3: DAX Query and Filter Context
• Understanding filter context in measures.
• How filter context is created by visuals, slicers, and filters.
• Interaction of row context and filter context.
• Use of CALCULATE to modify filter context.
• Examples showing context transition from row to filter context.

Module 4: DAX in PBIDT (Power BI Desktop Tool)
• Writing and debugging DAX in Power BI Desktop.
• Formula bar, measure pane, and table tools.
• Using Quick Measures and tooltips for guidance.
• Exploring performance analyzer for DAX tuning.
• Preview of external tools like DAX Studio and Tabular Editor.

Module 5: Introducing Evaluation Context
• Combining row and filter contexts under the term evaluation context.
• Context transition explained with examples (CALCULATE, row context to
filter context).
• How context affects measure results in different visuals.
• Examples using nested iterators and CALCULATE to illustrate context
evaluation.

Module 6: Introducing CALCULATE
• CALCULATE as the gateway to context transition.
• Basic syntax and usage patterns.
• Adding, modifying, and removing filters within CALCULATE.
• Use with ALL, FILTER, VALUES, REMOVEFILTERS.
• Troubleshooting common CALCULATE issues.

Module 7: DAX Time Intelligence
• Built-in time intelligence functions: DATESYTD, SAMEPERIODLASTYEAR,
DATEADD, etc.
• Pre-requisites: date table and marked as a Date Table.
• Handling YTD, QTD, MTD, rolling averages.
• Custom time intelligence with CALCULATE, FILTER, DATESBETWEEN.
• Common mistakes (non-contiguous dates, missing data).

Module 8: DAX Calculation Groups
• Introduction to calculation groups in Tabular Editor.
• Creating dynamic measures (e.g., YTD, QoQ, % of total).
• Syntax using SELECTEDMEASURE() and ISSELECTEDMEASURE().
• Managing format strings and precedence.
• Best practices to reduce measure explosion.

Module 9: Querying DAX
• DAX as a query language (not just calculated expressions).
• Writing EVALUATE statements.
• Using DEFINE MEASURE, VAR, and RETURN.
• Querying tables with filters, columns, and summarizations.
• Using DAX Studio for query testing and optimization.

Kursen levereras i samarbete med

Kontakta oss om denna kurs