Dax In Power BI Part I | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Dax In Power BI Part I


Format What’s this?
Starting From
RM 500.00
  1. 1 Day with 08 hours per day
  1. Mon 12 Sep 09:00 - Mon 12 Sep 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
Starting From
RM 500
  1. 1 Days
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy




Thank You

Our learning consultant will get back to you in 1 business day

Dax In Power BI Part I


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.

• 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


• Sales Executive / Managers

• Business Analysist

• Resource Planning Team

• Project Managers

• Purchasing Manager

• Financial Executive / Managers


• Familiar with creating formulas in Microsoft Excel

• Import data from various source into Power BI

• Understand relationship between tables

• Creating visual reports in Power BI


This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Expand All


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


• 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


• 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


• Mark as date table

• Using multiple dates

Module 8: Time Intelligence in DAX

• What is time intelligence?

• Time intelligence functions

• DATEADD function


• Running total

• Mixing time intelligence functions

• Semi-additive measures

• Calculation over weeks

Module 9: Hierarchies in DAX

• What are hierarchies?


• Percentages over hierarchies

• Parent-child hierarchies

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Course Reviews

No Remarks


0 Ratings