DAX for Power BI Training

2 days (10:00 AM - 5:00 PM Eastern)

$750.00

No open dates. Contact us to schedule.

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

View PDF
PDF
  • 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?

Request a Quote