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.

Data Science & Analytics

15 Hours

Description

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 Objectives

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

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 Understanding

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.


Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

DAX Calculations in Power BI – Beginners to Intermediate

Session 1: Introduction to DAX

  1. What is DAX?
  2. DAX data types
  3. Calculated Columns
  4. Measures
  5. Aggregation functions
  6. Counting values
  7. Conditional functions
  8. Handling errors
  9. Relational functions
  10. IF function
  11. SWITCH function

Session 2: Evaluation contexts

  1. Introduction to evaluation contexts
  2. Filter context
  3. Row context
  4. Filtering a table
  5. Using RELATED in a row context
  6. Filters and Relationships

Session 3: CALCULATE function

  1. Introduction to CALCULATE function CSV files
  2. CALCULATE syntax explanation
  3. CALCULATE examples
  4. CALCULATE operators
  5. KEEPFILTERS
  6. REMOVEFILTERS

Session 4: Table functions

  1. Introduction to Table functions
  2. Filtering a table
  3. Ignoring filters
  4. Mixing filters
  5. DISTINCT
  6. ALLSELECTED
  7. ALLEXCEPT

Session 5: Relationship functions

  1. Introduction to relationship functions
  2. RELATED
  3. RELATEDTABLE
  4. USERELATIONSHIP
  5. CROSSFILTER
  6. TREATAS

Session 6: Time Intelligence functions

  1. Introduction to time intelligence functions
  2. Creating Date table
  3. CALENDARAUTO, CALENDAR
  4. Aggregations over time - YTD, QTD, MTD
  5. DATESBETWEEN
  6. DATESINPERIOD
  7. DATEDIFF
  8. DATEADD
  9. SAMEPERIODLASTYEAR
  10. PREVIOUSMONTH
  11. PARALLELPERIOD
  12. Mixing time intelligence functions
  13. Semi-additive measures
  14. Calculations over weeks

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients