Course description
DAX Introduction - Tailored Course
DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot, and at Analysis Services developers that want to learn and master the DAX language.
The goal of the course is to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
You should be a competent Microsoft Excel user. You don’t need any experience of using DAX but we recommend that you attend our 2-day Microsoft Power BI Introduction course prior to taking this course.
Training Course Content
Introduction to DAX
- What is DAX?
- Naming Requirements
DAX Syntax
- Data Types
- DAX Code Formatting
- Rules & Guidelines
Basic DAX Functions
- Basic Aggregators
- Basic Iterators
- COUNTROWS Function
- DISTINCTCOUNT Function
Logical Functions
- IF Function
- SWITCH Function
- AND Function
- OR Function
- IFERROR Function
Filter Functions
- Introduction Evaluation, Row & Filter contexts
- FILTER Function
- CALCULATETABLE Function
- CALCULATE Function
Date & Time Functions
- CALENDAR Function
- CALENDARAUTO() Function
- DATE Function
- DATEVALUE Function
- YEAR Function
- MONTH Function
- WEEKDAY Function
- WEEKNUM Function
- FORMAT Function
- EDATE Function
- NOW Function
- TODAY() Function
- DATEDIFF Function
Information Functions
- Information Functions Overview
- HASONEVALUE Function
- ISFILTERED Function
- ISINSCOPE Function
- USERNAME Function
- USERPRINCIPALNAME Function
Relationship Functions
- RELATED Function
- RELATEDTABLE Function
- USERELATIONSHIP Function
Time-Intelligence Functions
- SAMEPERIODLASTYEAR Function
- DATEADD Function
- LASTDATE Function
- DATESMTD/DATESQTD/DATESYTD Functions
- TOTALMTD, TOTALQTD, TOTALYTD Functions
- Other Time Intelligence Semi-Additive Measures
Other Useful Functions
- DIVIDE Function
- RANKX Function
- ALL Function
- ALLSELECTED Function
- VALUES Function
- SUMMARIZE Function
- DATATABLE Function
Understand the Use of Parameter Tables
- What-If Parameter
- What if Parameter in Use
Creating Measures Using Variables
The DAX Studio Application Demonstration
- What is DAX Studio
- Format DAX Calculations in DAX Studio
- Evaluate a Calculation in DAX Studio
Request info
Welcome to Systematix, your gateway to a world of boundless learning and professional growth! At Systematix, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals and organisations...