Power BI Data Modeling with DAX

Course details

Power BI Desktop makes it easy to create basic data models. But if you need to report across time periods—for example, visualize year-over-year growth or compare sales or other data by month or quarter—you need Data Analysis Expressions (DAX). DAX is a language you can use to create formulas for Power BI that extend your data model. In this course, Gini von Courter covers the essentials of working with DAX, sharing best practices for data model design and optimization along the way. Learn how to work with DAX aggregate functions, add calculated columns, create measures, and work with DAX logical and filter functions.

Learning objectives
Apply data modeling basics.
Create a measure with operators.
Format, delete, and edit measures.
Add a calculated column.
Use basic DAX date and time functions.
Create a measure with DIVIDE.
Use DAX logical and filter functions.

Concepts

Introduction

Build powerful data models with DAX
What you'll need

Set Up the Data Model

Data modeling - The basics
Get data for your model
Check relationships
Save your data model

DAX Aggregate Functions

Create a measure with SUM
Understanding DAX syntax
Display the measure in a matrix
Format a measure
Create measures with COUNT functions
Delete or edit a measure
Check your data with COUNTBLANK
Create a measure with DISTINCTCOUNT

Measures and Calculated Columns

Add a calculated column
Understand explicit and implicit measures
Create a measure with operators
Create a measure with DIVIDE
Iterators and row context - SUMX
Basic DAX date and time functions

DAX Logical and Filter Functions

Use FIND
Use IF
Use OR to handle case sensitivity
Use CALCULATE to create a simple filter
Use SWITCH

Using DAX Time-Intelligence Functions

DAX time-intelligence functions
Summarize year-to-date information with DATESYTD
Visualize cumulative YTD data
Compare totals with SAMEPERIODLASTYEAR

Conclusion

Next steps