Power BI Data Modeling with DAX

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.

Introduction

• Build powerful data models with DAX
• What you will need

1. Set Up the Data Model

• Data modeling: The basics
• Get data for your model
• Check relationships

2. DAX Aggregate Functions

• 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

3. Measures and Calculated Columns

• 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

4. DAX Logical and Filter Functions

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

5. Using DAX Time Intelligence Functions

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

Conclusion

• Next steps