DAX Functions in Power BI

SKU: 3484
5 Lesson
|
3 Hours
Data Analysis Expressions (DAX) functions form the calculation engine of Power BI reports. They are used to create measures, calculated columns and calculated tables that determine how totals, ratios, comparisons, and time based metrics are computed across dashboards. In this 3 hour training, learners focus on the DAX functions most commonly applied in business reporting and understand how row context and filter context directly influence calculation results. The session emphasizes correct function usage to prevent inaccurate totals and maintain consistency in analytical reporting.

Overview

What Will You Learn

  • DAX Syntax and Formula Structure
  • Aggregation Functions
  • Logical and Conditional Functions
  • Text and Data Type Functions
  • Date and Basic Time Intelligence Functions
  • Filter Modification Functions
  • Row Context and Filter Context Fundamentals
  • Measure Calculation Validation

Prerequisites

  • Basic Power BI Desktop Usage
  • Understanding of Tables and Relationships
  • Basic Report Creation Knowledge
  • Introductory DAX Knowledge

Who Should Do This Training

  • Business Analysts
  • MIS and Reporting Professionals
  • Finance Analysts
  • Sales Analysts
  • HR Analysts
  • Power BI Developers
  • Data Support Staff

Course Curriculum

1. SUM
2. AVERAGE
3. COUNT
4. DISTINCTCOUNT
5. MIN
6. MAX
7. DIVIDE
8. Ratios and Percentage Logic
1. IF
2. SWITCH
3. AND
4. OR
5. Conditional Expression Logic
1. LEFT
2. RIGHT
3. MID
4. CONCATENATE
5. VALUE
6. FORMAT
7. Data Type Control
1. DATE
2. YEAR
3. MONTH
4. TODAY
5. TOTALYTD
6. SAMEPERIODLASTYEAR
7. Simple Period Comparisons
1. CALCULATE
2. FILTER
3. ALL
4. ALLEXCEPT
5. VALUES
6. Context Transition Understanding
Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)
Drop Us a Query
Fields marked * are mandatory

Request For Live Demo Class

Course Fees

Online Class Room Program

US $ 139.00
100% Money Back Guarantee
  • Duration : 3 Hrs
  • Plus Self Paced

Classes Starting From

  • Fast Track Batch 25 Jun 2026
  • Weekday Batch 29 Jun 2026
  • Weekend Batch 27 Jun 2026

Corporate Training

Corporate Training
  • Customized Training Delivery Model
  • Flexible Training Schedule Options
  • Industry Experienced Trainers
  • 24x7 Support

Trusted By Top Companies Worldwide

MITSUBISHI
Emirates
BECHTEL
Tech Mahindra
Techmill
metacube
Fareportal
Trelleborg
Capgemini
AU Small Finance Bank
United Nations
Inter Mid
SoftFlex
align
utthunga
Rimini Street
EJADAH
Yash Technologies
suyati
Hettich
APPCINO

Want to know Today's Offer

Reviews


Login
Don't have an account?
Sign Up

Our Alumni works at

HCL
FAI
YOKAGAWA
Tech Mahindra
SOCIETE GENERALE
SAMSUNG
EMIDS
DHL
FedEx
PayPal
BOSCH
asian paints
MICRO FOCUS
hgs
eClerx
Nasdaq
Persistent
CSS CORP
×

Your Shopping Cart


Your shopping cart is empty.