English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 06m | 547 MB
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.
Topics include:
- Data modeling basics
- Creating a measure with operators
- Formatting, deleting, and editing measures
- Adding a calculated column
- Basic DAX date and time functions
- Creating a measure with DIVIDE
- Using DAX logical and filter functions
Table of Contents
1 Build powerful data models with DAX
2 What you will need
3 Data modeling The basics
4 Get data for your model
5 Check relationships
6 Create a measure with SUM
7 Understanding DAX syntax
8 Display the measure in a matrix
9 Format a measure
10 Create measures with COUNT and COUNTROWS
11 Delete or edit a measure
12 Check your data with COUNTBLANK
13 Create a measure with DISTINCTCOUNT
14 Add a calculated column
15 Understand explicit vs. implicit measures
16 Create a measure with operators
17 Create a measure with DIVIDE
18 Iterators and row context SUMX
19 Basic DAX date and time functions
20 Use FIND
21 Use IF
22 Use OR to handle case sensitivity
23 Use CALCULATE to create a simple filter
24 Next steps
Resolve the captcha to access the links!