DAX in Power Pivot Add-in

DAXPP
Duration 1 day
0 ITK points
4 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

Download PDF detail
Download PDF detail (no terms)

The prices are without VAT.

DAX in Power Pivot Add-in

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details

DAX in Power Pivot Add-in

Previous courses

Related courses

GOPAS Praha

GOPAS Brno

GOPAS Bratislava

Business details