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.