Power BI Data Modeling with DAX

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