###### Microsoft Excel 2013 DAX formulas for Power Pivot

Audience: This course is designed for those who need to create formulas using the Data Analysis Expressions language (DAX) to analyse Power Pivot data. Many of the functions are similar to Excel’s but it is vital that you understand the evaluation context.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel 2013 DAX formulas for Power Pivot training course is delivered at our training centre in London situated close to Liverpool Street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

###### All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

View Scheduled Public Courses

##### After completing this course, students will be able to:
• Write and understand DAX formulas
• Use DAX Aggregate functions
• Understand the DAX evaluation context
• Use DAX Date and Time functions
• Use DAX Text functions
• Use DAX Mathematical functions
• Use DAX Time Intelligence functions

• ##### Course Content
###### Module 1: Getting started with DAX
• Overview of creating the data model
• Where to write DAX
• Creating calculated columns
• Creating calculated fields
• Operators and operator precedence
• Data types
###### Module 2: DAX Aggregate functions
• SUM, AVERAGE, MIN, COUNT,COUNTA and MAX
• SUMX, AVERAGEX, MINX, COUNTX,COUNTAX and MAXX
• Statistical functions
###### Module 3: The fundamental DAX functions
• Understanding evaluation contexts and relationships
• Filter and Row Context
• ALL function
• ALLEXCEPT function
• CALCULATE function
• CALCULATETABLE function
• RELATED function
• RELATEDTABLE function
• FILTER function
• IFERROR function
• DISTINCT function
• EARLIER function
###### Module 4: DAX Date and Time functions
• DATE function
• HOUR function
• MONTH function
• YEAR function
• DAY function
• WEEKDAY function
• WEEKNUM function
###### Module 5: DAX Text functions
• CONCATENATE function
• LEFT function
• RIGHT function
• TRIM function
• SUBSTITUTE function
###### Module 6: DAX Mathematical functions
• INT function
• MOD function
• ROUND function
• ROUNDUP function
• ROUNDDOWN function
###### Module 7: DAX Time Intelligence functions
• Creating comparisons across comparable time periods.
• CLOSINGBALANCEMONTH function
• CLOSINGBALANCEQUARTER function
• CLOSINGBALANCEYEAR function
• DATESBETWEEN function
• DATESINPERIOD function
• DATESMTD function
• DATESQTD function
• DATESYTD function
• ENDOFMONTH function
• ENDOFQUARTER function
• ENDOFYEAR function
• FIRSTDATE function
• FIRSTNONBLANK function
• LASTDATE function
• LASTNONBLANK function
• NEXTDAY function
• NEXTMONTH function
• NEXTQUARTER function
• NEXTYEAR function
• OPENINGBALANCEMONTH function
• OPENINGBALANCEQUARTER function
• OPENINGBALANCEYEAR function
• PARALLELPERIOD function
• PREVIOUSDAY function
• PREVIOUSMONTH function
• PREVIOUSQUARTER function
• PREVIOUSYEAR function
• SAMEPERIODLASTYEAR function
• STARTOFMONTH function
• STARTOFQUARTER function
• STARTOFYEAR function
• TOTALMTD function
• TOTALQTD function
• TOTALYTD function

### Call us now for further information Tel:08001601666

• Floor 7 Crystal Gate, 28 - 30 Worship Street London
EC2A 2AH