Description

Power Pivot, Excel's rock-solid data analysis tool? Get to know it better in our training Excel Power Pivot: Module 2 - (DAX) Functions for powerful data analysis.

Power Pivot has plenty of new functions. Some are self-explanatory, but for most of them you'll be glad to have a Power Pivot expert on hand. In this training you'll discover the real power of functions combined with PivotTables.

Sign up now for this training Excel Power Pivot: Module 2 - (DAX) Functions for powerful data analysis and take your knowledge further.

Objectives

Struggling with the functions in Power Pivot?

Sign up quickly so that you:

• Get an overview of the different types of functions in Power Pivot

• Can implement these functions yourself in your own analysis solutions

Target audience

Anyone already familiar with Power Pivot who wants to learn and use more functions.

Prerequisites

It's important that you've taken the course 'Excel PowerPivot - Introduction'.

Contents

Part 1: Recap of the data model

• Requirements of an efficient model

• Importing data via Power Query

• Optimising the data model (relationships, date table)

Part 2: Context

• Row Context

• Filter Context

Part 3: Basic functions

• SUM, MIN, MAX, AVERAGE, COUNT, COUNTA

• COUNTROWS

• BLANK

• HASONEVALUE

• SWITCH

Part 4: Iterator functions

• What are iterator functions?

• SUMX, AVERAGEX

• FILTER

Part 5: Changing context

• CALCULATE, CALCULATETABLE

• Context transition

Part 6: Filter functions

• ALL, ALLEXCEPT, ALLSELECTED

• FILTER

• RANKX

• TOPN

• VALUES

Part 7: Date and time functions

• DATEADD

• DATESBETWEEN, DATESINPERIOD

• DATESYTD / DATESMTD / DATESQTD

• TOTALYTD / TOTALMTD / TOTALQTD

• ENDOFMONTH / ENDOFQUARTER / ENDOFYEAR

• FIRSTDATE / LASTDATE

• FIRSTNONBLANK / LASTNONBLANK

• NEXTDAY / NEXTMONTH / NEXTQUARTER / NEXTYEAR

• PREVIOUSDAY / PREVIOUSMONTH / PREVIOUSQUARTER / PREVIOUSYEAR

• SAMEPERIODLASTYEAR

• STARTOFMONTH / STARTOFQUARTER / STARTOFYEAR

Part 8: KPI (Key Performance Indicators)

• Creating a KPI in Power Pivot

Part 9: Cube functions (optional)

• Converting PivotTable data into functions

Part 10: Working with multiple data fields (optional)

• Multiple relationships between a table and the date table

• Multiple date tables