This one-day training will help you understand the new types of functions in Excel, particularly in Power Pivot Add-in. We will learn to distinguish computed columns from measures, we will find out which is more suitable for various kinds of [...]
  • DAXPP
  • Duration 1 day
  • 0 ITK points
  • 2 terms
  • Praha (4 000 Kč)

    Brno (4 000 Kč)

    Bratislava (170 €)

  • Advanced

This one-day training will help you understand the new types of functions in Excel, particularly in Power Pivot Add-in. We will learn to distinguish computed columns from measures, we will find out which is more suitable for various kinds of situations. “Table functions” that can derive a whole table, or querying the workbook data model will be discussed as well. We will also explain virtual relations, find the technical limits of functions and handle errors in calculations.

»
  • For all users who need to understand the DAX language used in Power Pivot Add-in for Excel.
  • Printed handouts.
  • Introduction to individual DAX areas
    • Calculated columns
    • Measures
    • X functions
    • Table functions
  • Data types and formats
  • Effect of active vs. non-active relations
  • Understanding of cross-filters by calculations
  • DAX as querying language
  • Evaluation Contexts
    • Filter and Row Context
    • CALCULATE
  • Path function and hierarchical calculations
  • Time intelligence calculations
  • Advanced table functions
  • Physical vs. virtual relations in calculations
  • Star vs. Snowflake model and their affect to calculations
Current offer
Training location
Course language

The prices are without VAT.