Masterclass DAX (2 days)

Introduction

If you're seeking a deeper understanding of DAX formulas and want to learn the exact difference between Row Context and Filter Context, then this training is for you.

In this training, you will learn how to create advanced DAX formulas in both Calculated Columns and Measures to gain even more insights from your data.

Topics

  • Difference between Row context and Filter context.
  • Calculated Columns and Measures: when to use what?
  • Looking up values in other tables: LOOKUPVALUE, RELATED + RELATEDTABLE
  • Summarizing numbers with: SUM, AVERAGE + COUNT
  • Modifying Filter Context with: CALCULATE + FILTER
  • Working with Time Intelligence functions: PREVIOUSMONTH, PARALLEPERIOD + DATESYTD
  • Calculating Sub Totals with: SUMMARIZE + CALCULATETABLE
  • How to handle many-to-many relationships?
  • Securing data with Row-Level Security

Target Audience

This 2-day course is intended for BI Developers and advanced PowerPivot/Power BI users.

Prerequisites

You have a good knowledge of Power BI, Power Pivot, or Tabular Models.

Information

Interested in this training? Click here for more information.