Foresight BI

Super Store Data

Welcome and Introductions

Pre-requisites and Outline

Quick overview of DAX

pre-requisites and outline

Importance of DAX in Power BI

Understanding our case study data

Understanding the case study data model

Intro to Calculated Columns

Intro to Calculated Tables

Introduction to Measures

9. Intro to Row Level Security

Assignment: Introduction to DAX

Pillars of DAX

Understanding Model Cardinality and Filters

Understanding Cross Filtering Direction

Intro to DAX Functions

Using the IF function

Using SWITCH Function

Using RELATED function to fetch columns from other tables

Intro to ALL and ALLEXCEPT

Intro to VALUES and DISTINCT functions

Assignment: DAX Functions

Intro to Evaluation Context

Understanding Filter Context

How DAX works behind the scenes

Intro to Aggregators and Iterators

Understanding Iterators with SUMX

Aggregating on a Filtered Table

How DAX computes filtered aggregates 1

How DAX computes filtered aggregates 2

Expanding Filters with ALL function

Assignment: SUMX, FILTER

Intro to CALCULATE function

Intro to Context Transition

Understanding Row Context within a Measure

Understanding Context Transition in Measures

Intro to CALCULATE in Measures

Using CALCULATE with multiple column filters

Using the OR operator to filter for multiple values on same column

Using the IN operator in place of OR operators

Understanding the 4 types of filtering

Using ALL function as a CALCULATE filter argument

Understanding how ALL filters columns in DAX

Understanding how ALL filters columns in DAX (b)

Understanding Variables

Activating filters between tables with CALCULATE and CROSSFILTER

Assignment: CALCULATE

Overview of Time Intelligence in DAX

Using CALENDARAUTO function to generate a Date Table

Using YEAR or FORMAT function to create Year Column

Creating and Sorting Month column with FORMAT and MONTH functions

Setting up our table for Time Intelligence Reporting

Calculating previous month values with PREVIOUSMONTH function

Expanding the PREVIOUSMONTH function 1

Expanding PREVIOUSMONTH function with VALUES and DATEADD

Calculating Year to Date values with CALCULATE and DATESYTD

Expanding the DATESYTD function with FILTER, DATE and DATESBETWEEN

Using TOTALYTD to calculate Year to Date Values

Calculating values for the same period in a previous year with SAMEPERIODLASTYEAR

Expanding SAMPERIODLASTYEAR function with VALUES and DATEADD

Assignment: Time intelligence