Introduction to DAX for Power BI

Agenda

MODULE 1- GETTING STARTED WITH DAX

• INTRODUCTION TODAX
• CREATING OBJECTS WITHDAX
• CONTEXT AND RULES OF EVALUATION
• VARIABLES,COMMENTS,AND TESTING

MODULE 2- PERFORMING BASIC CALCULATIONS

• GETTING STARTED
• IMPLICIT MEASURES
• ADDING QUICK MEASURES
• WORKING WITH DAX DATA TYPES .
• DOING BASIC MATH
• USING LOGIC IN YOUR CALCULATIONS
• USING THE IF() FUNCTION
• NESTED IF()
• USING THE SWITCH() FUNCTION
• ADVANCED SWITCH()
• LOGICAL OPERATORS & FUNCTIONS- -, OR(), &&, AND(), NOT()
• AGGREGATING AND SUMMARIZING DATA
• THE SUM() FUNCTION

MODULE 3- WORKING WITH CONTEXT IN THE DATA MODEL

• CONTEXT DEFINED
• DATA MODELING BASICS
• INTRODUCTION TO DIMENSIONAL MODELING
• RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT
• GETTING DATA FROM OTHER TABLES
• USING RELATED() AND RELATEDTABLE
• LOOKING UP DATA WITHOUT USING RELATIONSHIPS
• MODIFYING THE CONTEXT USING CALCULATE()

MODULE 4- PERFORMING MORE ADVANCED CALCULATIONS

• THE DAX ITERATOR FUNCTIONS
• USING TABLE MANIPULATION FUNCTIONS

MODULE 5- WORKING WITH TIME

• PERFORMING DATE CALCULATIONS
• WORKING WITH DATE TABLES
• GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION
• DEFINING CUSTOM OPERATING PERIODS
• YTD, QTD, AND MTD CALCULATIONS
• CUSTOM TO-DATE CALCULATIONS
• FINDING YEAR-OVER-YEAR CHANGE
• FINDING MOVING AVERAGES

MODULE 6- ENHANCING THE USER EXPERIENCE

• CONTROLLING VISIBILITYOF YOUR MEASURES
• USING WHAT-IF PARAMETERS
• ADDING BANDING
• USING DAX TO PROVIDE ROW-LEVEL SECURITY