DAX Calculations in Power BI – Beginners to Intermediate

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI with 5-star rated Business Intelligence Specialist & Certified IT Trainer.
Duration: 3 Days
Hours: 15 Hours
Training Level: All Level
Batch Six
Monday, October 21, 2024
11:00 AM - 04:00 PM (Eastern Time)
Batch Seven
Monday, December 09, 2024
11:00 AM - 04:00 PM (Eastern Time)
Live Session
Single Attendee
$299.00 $499.00
Live Session
Recorded
Single Attendee
$349.00 $583.00
6 month Access for Recorded
Live+Recorded
Single Attendee
$399.00 $666.00
6 month Access for Recorded

About the Course

Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.

Dr. Sameer Rohadia, a Microsoft Certified Power BI Professional & Microsoft Certified Trainer, has trained 9000+ Industry professionals, University Professors and students in the area of MS Power BI and MS Excel. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners’ time.

In this 15-hour virtual & hands-on course, you will learn how to create relationships, measures, calculated columns, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch! 

Course Objective

Enjoy clear and concise step by step lessons from a 5-star rated BI Specialist & Certified IT Trainer

Use DAX and learn what you can achieve with DAX if utilized well

Structure and format DAX formula

Have a comprehensive understanding of creating data models and developing DAX formulas in Microsoft Power BI

Create calculated Columns and Measures using DAX in Power BI

Perform sophisticated calculations such as Time Intelligence, Relationship and Table functions

Audit your formulas by understanding Filter and Row context

Who is the Target Audience?

Aspiring data professionals looking to master the #1 BI tool on the market.

Excel users who want to learn how to create Professional reports in Power BI.

Data Analytics or BI professionals looking to build expert-level DAX + Power BI skills.

Students looking for a comprehensive, engaging and highly interactive approach to training.

Basic Knowledge

Some basic knowledge in Power BI is strongly encouraged.

Recommend completing my “Microsoft Power BI Bootcamp” course available on Simpliv platform (25-hour virtual course) before registering for this one.


Curriculum
Total Duration: 15 Hours
Introduction to DAX

What is DAX?  

DAX data types  

Calculated Columns  

Measures  

Aggregation functions  

Counting values  

Conditional functions  

Handling errors  

Relational functions  

IF function  

SWITCH function  

Evaluation contexts

Introduction to evaluation contexts  

Filter context  

Row context  

Filtering a table  

Using RELATED in a row context  

Filters and Relationships  

CALCULATE function

Introduction to CALCULATE function CSV files  

CALCULATE syntax explanation  

CALCULATE examples  

CALCULATE operators  

KEEPFILTERS  

REMOVEFILTERS  

Table functions

Introduction to Table functions  

Filtering a table  

Ignoring filters  

Mixing filters  

DISTINCT  

ALLSELECTED  

ALLEXCEPT  

Relationship functions

Introduction to relationship functions  

RELATED  

RELATEDTABLE  

USERELATIONSHIP  

CROSSFILTER  

TREATAS  

Time Intelligence functions

Introduction to time intelligence functions  

Creating Date table  

CALENDARAUTO, CALENDAR  

Aggregations over time - YTD, QTD, MTD  

DATESBETWEEN  

DATESINPERIOD  

DATEDIFF  

DATEADD  

SAMEPERIODLASTYEAR  

PREVIOUSMONTH  

PARALLELPERIOD  

Mixing time intelligence functions  

Semi-additive measures  

Calculations over weeks