Course 97020
Power BI - DAX Programming - Part 4

Course Description

In this 2 hour course, DAX (Data Analysis Expressions) is a formula language developed by the SQL Server Analysis Services team at Microsoft. Many of the functions are similar to Excel formulas and functions. DAX can be used to define custom calculations for Calculated Columns and for Measures (also known as calculated fields). A Measure is most commonly referred to as a cross section of rows/columns contained in an Excel PivotTable. However, they are now used in Power BI to perform complicated calculations.

Corresponding Exam: None

Who should Attend:

This course is for anyone looking to get an understanding of PowerBI and has attended Power BI Overview Part 1, Power BI Desktop Part 2, and Power BI Web Service Part 3

Course Outline

Module 1: DAX Formula Overview

We will first discuss basic structure and define common development techniques.

Module 2: Date and Time DAX Functions

These functions help to create calculations based on dates and times. Many of the functions in DAX are similar to the Excel date and time functions. However, DAX functions use a datetime Data Type, and can take values from a column as well as an argument.

Module 3: Time Intelligence DAX Functions

- These functions help to create calculations that use built-in knowledge about calendars and dates. This will enable you to manipulate data using time periods, including days, months, quarters, and years. Then, you can build and compare calculations over those periods. By using time and date ranges in combination with aggregations (performing calculations on a range of data) or calculations, you can build meaningful comparisons across comparable time periods for sales, inventory, and so on.

Module 4: Filter DAX Functions

These functions help you return specific Data Types, look up values in related tables, and Filter by related values. Lookup functions work by using tables and relationships between them like a database. Filtering functions allow you to manipulate data to create dynamic calculations.

Module 5: Information DAX Functions

These functions look at a table, column, cell, or row and provide an argument to another function. This will tell whether or not the value matches the expected type.

Module 6: Logical DAX Functions

These functions return information about values in an expression. For example, the TRUE function lets you know whether or not an expression being evaluated will return a TRUE value.

Module 7: Math and Trig DAX Functions

Mathematical functions in DAX are similar to Excel's Mathematical and Trigonometric functions. However, there are some differences in the numeric data types used by DAX functions.

Module 8: Other DAX Functions

These functions perform unique actions that cannot be defined by any of the categories for most other functions.

Module 9: Parent/Child DAX Functions

These DAX functions help users manage data that is presented as a Parent/Child hierarchy in their data models.

Module 10: Statistical DAX Functions

These functions perform aggregations (performing calculations on a range of data), in addition to creating sums and averages, or finding minimum and maximum values.

Module 11: Text DAX Functions

With these functions, you can return part of a string, search for text within a string, or concatenate string values. Additional functions are used for controlling the formats for dates, times, and numbers.

Prerequisites

  • Courses: Power BI Overview Part 1, Power BI Desktop Part 2, and Power BI Web Service Part 3

More SQL Server Training


*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.