Overview
-
Take your data modeling skills to the next level. Learn how to leverage Data Analysis Expressions (DAX) to create formulas for Power BI that extend your data model.
Syllabus
-
Introduction
- Build powerful data models with DAX
- What you will need
- Data modeling: The basics
- Get data for your model
- Check relationships
- Create a measure with SUM
- Understanding DAX syntax
- Display the measure in a matrix
- Format a measure
- Create measures with COUNT and COUNTROWS
- Delete or edit a measure
- Check your data with COUNTBLANK
- Create a measure with DISTINCTCOUNT
- Add a calculated column
- Understand explicit vs. implicit measures
- Create a measure with operators
- Create a measure with DIVIDE
- Iterators and row context: SUMX
- Basic DAX date and time functions
- Use FIND
- Use IF
- Use OR to handle case sensitivity
- Use CALCULATE to create a simple filter
- Use SWITCH
- DAX time intelligence functions
- Summarize year-to-date with DATESYTD
- Visualize cumulative YTD data
- Compare totals with SAMEPERIODLASTYEAR
- Next steps
