Dax in Power BI Part 1

Course Objectives

  • being able to select, join, filter data in a dynamic way
  • create smarter calculated columns and/or measures by which you can limit the data the dashboard has to fetch and visualize
  • shows a cumulative growth in value overtime
  • compare sales in a date range to another date range

Target Audience

  • 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 Modules

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

Get To Know The Trainer

Trainer Lim

 

Lim has been working in the IT industry for the past 20 years. He leads, plans and supports a functionally organized, technically oriented team and environment with a wide variety of technical activities and service operations.He is good in developing and implementing IT initiatives for regional service operation activities and actively participates in global projects to align corporate/regional direction and IT standard according to ITIL operational framework and software development.

Trainer CK

 4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

Trainer P.L

 4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

*T&C Applies

Optimized by Optimole

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

[nextend_social_login]

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

[nextend_social_login]

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?