

DAX for Power BI Training
2 days (10:00 AM - 5:00 PM Eastern)
$750.00
Register for a live online class.
Details
Subjects Covered
Prerequisites
Setup Requirements
Details
Course Details
This course teaches you how to create calculated columns and measures using DAX, including understanding complicated DAX functions like CALCULATE, VALUES, and EARLIER. It also covers writing DAX queries to interrogate databases.
During the course, you will pick up many clever techniques for building data models, including ways to model multiple calendars, cope with different financial year-ends, and apply dynamic security.
This training uses Power BI Desktop for editing measures; however, it is just as helpful if you use PowerPivot or SQL Server Analysis Services (tabular model).
Subjects Covered
- Ways to edit DAX
- Power BI
- PowerPivot
- SSAS Tabular
- DAX Studio
- Data model basics
- Linking to data
- Creating a data model
- Calculated columns
- Creating calculated columns
- IF and SWITCH
- Showing RELATED data
- Dealing with blanks
- Basic measures
- Creating measures
- Understanding filter context
- Using a measures table
- AggregateX functions
- The CALCULATE function
- Filter context revisited
- Removing and replacing context
- Context transition
- The VALUES function
- The HASONEVALUE function
- Listing single values
- Parameter tables
- Dynamic measures
- The ISFILTERED function
- The ALLSELECTED FUNCTION
- Dynamic titles
- The FILTER function
- Row context
- Iterator functions
- Applying criteria
- Understanding EARLIER (*)
- How it works
- Banding using EARLIER
- Ranking using EARLIER
- Variables
- Creating variables
- Using for debugging
- Calendars and dates
- Creating a calendar
- Date-based functions
- Advanced date functions
- Multiple relationships
- Moving averages
- Parent-child hierarchies (*)
- The PATH functions
- Displaying different levels
- Making the results neater
Prerequisites
Before Taking this Class
Power BI Fundamentals or equivalent.Setup Requirements
Software/Setup For this Class
Power BI Desktop
Onsite Training
Do you have five (5) or more people needing this class and want us to deliver it at your location?