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

Dax In Power BI Part II


Format What’s this?
Starting From
RM 500.00
  1. 1 Day with 08 hours per day
  1. Tue 13 Sep 09:00 - Tue 13 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 II


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


• Attended PART I

• 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 10: Data Lineage and TREATAS

• What is data lineage?

• TREATAS function

Module 11: Expanded Tables

• Filters are tables!

• Difference between base tables and expanded tables

• Filtering a column

Module 12: Arbitrarily Shaped Filters

• What are arbitrarily shaped filters?

• Example of an arbitrarily shaped filter

Module 13: ALLSELECTED and Shadow Filter Contexts

• ALLSELECTED function revisited

• Shadow filter contexts

Module 14: Segmentation

• Static segmentation

• Circular dependency in calculated tables

• Dynamic segmentation

Module 15: Many-to-many Relationships

• How to handle many-to-many relationships

• Bidirectional filtering

• Expanded table filtering

• Comparison of the different techniques

Module 16: Ambiguity and Bidirectional Filters

• Understanding ambiguity

Module 17: Relationships at Different Granularities

• Working at different granularity

• Using TREATAS function

• Calculated tables to slice dimensions

• Leveraging weak relationships

• Scenario recap

• Checking granularity in the report

• Hiding or reallocating

Module 18: Querying with DAX

• Working with tables and queries

• EVALUATE syntax



• SUMMARIZE function


• CROSSJOIN function

• TOPN and GENERATE functions

• ROW and DATATABLE functions

• Tables and relationships


• GROUPBY functions

• Query measures

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