Course Details
Duration: 1 Day; Instructor-led
DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models in Power BI. Learning how to create effective DAX formulas will help you get the most out of your data.
Audience
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Prerequisites
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to :
- Enhance your productivity using ribbons in PowerPoint
- Move beyond default PowerPoint templates
- Create impressive presentations using templates
Upon completion of this program, participants should be able to:
- Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
- Performing Calculation, Basic Formula and Functions
- Modify worksheet & Formatting Worksheet
- Printing and managing large workbook
Outlines
Module 1: Introduction to DAX
- What is DAX?
- DAX data types
- Calculated columns
- Measures
- Aggregation functions
- Counting values
- Conditional functions
- Handling errors
- Using variables
- Mathematical functions
- Relational functions
Module 2: Table Functions
- Introduction to table functions
- Filtering a table
- Ignoring filters
- Mixing filters
- DISTINCT Function
- How many values for a column?
- ALLSELECTED function
- RELATEDTABLE function
- Tables and relationships
- Tables with one row and one column
- Table variables
Module 3: Evaluation Contexts
- Introduction to evaluation contexts
- Filter context
- Row context
- Context errors
- Filtering a table
- Using RELATED in a row context
- Ranking by price
- Evaluation contexts and relationships
- Filters and relationships
Module 4: Calculate Function
- Introduction to CALCULATE function
- CALCULATE function examples
- CALCULATE function recap
- What is a filter context?
- KEEPFILTERS function
- CALCULATE operators
- Use one column only in a compact syntax
- Variables and evaluation contexts
Module 5: Advanced Evaluation Contexts
- CALCULATE modifiers
- USERELATIONSHIP function
- CROSSFILTER function
- ALL function
- ALLSELECTED function
- KEEPFILTERS function
- Context transition
- Circular dependency
- CALCULATE execution order
Module 6: Iterators
- Working with iterators
- MINX and MAXX functions
- Useful iterators
- RANKX function
- ISINSCOPE function
Module 7: Building a Date Table
- Introduction to date tables
- Auto Date/Time
- CALENDARAUTO function
- Mark as date table
- Using multiple dates
Module 8: Time Intelligence in DAX
- What is time intelligence?
- Time intelligence functions
- DATEADD function
- DATESINPERIOD function
- Running total
- Mixing time intelligence functions
- Semi-additive measures
- Calculation over weeks
Module 9: Hierarchies in DAX
- What are hierarchies?
- FILTER and CROSSFILTER function
- Percentages over hierarchies
- Parent-child hierarchies
