Pages

Courses

ALL COURSES

Resources

ALL RESOURCES

Blogs

ALL BLOGS

Courses

ALL COURSES

Certifications

ALL CERTIFICATIONS

Instructors

ALL INSTRUCTORS

Mastering DAX for Microsoft Power BI

Learn the full range of DAX functions in Power BI.

DAX is the native language behind Microsoft PowerBI and other Microsoft data tools. It’s designed as a flexible, powerful syntax for working with various data types and crafting functions to manipulate and analyze data.    

Even for beginners, PowerBI out of the box offers incredible analysis capability. However, for those who are comfortable with basic features and are ready to truly unlock PowerBI’s potential, DAX is the key. Learning to use DAX within PowerBI gives you the power to perform incredibly fine-grained analysis and data manipulation.

In this class, you will get hands-on experience with DAX and learn it’s full range of functions. Led by an expert, you’ll get practice applying DAX skills to real-world datasets and real-world analysis problems. You’ll leave class ready to extend your role well beyond that of most PowerBI users – applying skills to manipulate, analyze, and communicate about data precisely and powerfully. 

Duration
3 days/24 hours of instruction
Public Classroom Pricing

Starting at: $1795(USD)

$2350(CAD)

GSA Price: $1685

Group Rate: $1695

Private Group Pricing

Have a group of 5 or more students? Request special pricing for private group training today.

Register Now Private Group Training

Get the full details on this course. Download the .PDF Brochure below:

Part 1: Introduction to DAX

  1. What is DAX?
  2. Why use DAX with Power BI
  3. Calculated Columns vs Measures
  4. Types of Functions
    1. Logical Functions
    2. Table manipulation functions
    3. Date and time functions
    4. Filter functions
    5. Financial functions
    6. Math and Trig functions 
    7. Parent and Child functions
    8. Relationship functions 
    9. Statistical functions
    10. Text functions
    11. Time intelligence functions

Part 2: Logical functions

  1. TRUE
  2. FALSE
  3. IF
  4. IFERROR
  5. AND
  6. OR
  7. SWITCH
  8. COALESCE

Part 3: Tables

  1. Tables Overview
  2. Filtering Tables
    1. FILTERS
    2. TOPN
  3. Summarizing Tables
    1. SUMMARIZE
    2. SUMMARIZECOLUMNS
    3. ROLLUP
    4. GROUPBY
  4. Generating Tables
  5. Distinct Values
    1. DISTINCT column
    2. DISTINCT table
  6. Joining Tables
    1. CROSSJOIN
    2. NATURALINNERJOIN
    3. NATURALLEFTOUTERJOIN
  7. Adding Values
    1. Columns
    2. Missing items
  8. Table Constructor

Part 4: Date and Time Functions

  1. Date and Time Functions Overviews
  2. Units of Time
  3. Creating a Calendar
    1. CALENDAR
    2. CALENDARAUTO
  4. Dates
  5. TODAY
  6. NOW
  7. TIME
  8. TIMEVALUE

Part 5: Filter Functions

  1. Filter Functions Overview
  2. Filtering Tables
    1. FILTER
    2. REMOVEFILTERS
    3. ALL (ALL, ALLCROSSFILTERED, ALLEXCEPT, ALLNOBLANKROW, & ALLSELECTED)
    4. CALCULATETABLE
    5. KEEPFILTERS
  3. CALCULATE
  4. LOOKUPVALUE
  5. SELECTEDVALUE

Part 6: Financial functions

  1. Accrued Interest
    1. ACCRINT
    2. ACCRINTM
  2. Depreciation
    1. DB
    2. DDB

Part 7: Relationships Functions

  1. CROSSFILTERS
  2. RELATED
  3. RELATEDTABLE
  4. USERELATIONSHIP
  5. Parent and Child Functions
    1. PATH
    2. PATHCONTAINS
    3. PATHITEM
    4. PATHITEMREVERSE

Part 8: Text functions

  1. FIND
  2. SEARCH
  3. REPLACE
  4. FORMAT
  5. LOWER
  6. UPPER
  7. RIGHT
  8. LEFT
  9. COMBINEVALUES
  10. CONCATENATE
  11. CONCATENATEX
  12. EXACT
  13. FIXED
  14. LEN
  15. MID
  16. SUBSTITUTE
  17. TRIM
  18. VALUE

Part 9: Statistical functions

  1. Central Tendencies
    1. Averages
    2. Means
    3. Geo means
  2. Counting
    1. Counting and COUNTX
    2. Blanks, and rows
    3. Distinct count: distinct, approximate, no blank
  3. Min/Max
    1. MAX, MAXA and MAXX
    2. MIN, MINA and MINX
  4. Sample
  5. Distributions
    1. Normal
    2. Exponential
    3. Beta
    4. Poisson
  6. Inverse
  7. Percentiles
  8. Ranking
  9. Standard Deviation
  10. Variance
    1. VAR.P and VARX.P
    2. VAR.S and VARS.P

Professionals who take this course need to be familiar with Microsoft Power BI’s basic features and already feel comfortable with navigating both the Desktop and Online version of the tool. It is recommended to take our Microsoft Power BI Boot Camp prior to this course, or have equivalent work experience.

Some professionals who would find this course particularly beneficial include:

  • Analysts
  • Database Administrators
  • Senior Business Intelligence Architects
  • Business Intelligence Consultants
  • Senior Business Analysts
  • Digital Marketers
  • Data Strategists
  • IT Specialists
  • IT Managers
  • IT Directors
  • Financial Specialists

  • Apply a wide range of available DAX functions and when you should use them
  • Manipulate data based on date, time, currency, integer values, and more
  • Expertly analyze data using powerful statistical functions
  • Build and manipulate tables with a wide range of data sources
  • Design and analyze data using boolean logic
  • Tease apart sophisticated data relationships to find insights
  • Filter through large data sets quickly and effortlessly
  • Work with and manipulate text values in Power BI 

Mastering DAX for Microsoft Power BI Schedule

Location
Date
USD EUR CAD
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9fQAD', 'startDate' => '2022-06-13', 'startTime' => '10:00 AM', 'endDate' => '2022-06-15', 'endTime' => '6:00 PM', 'name' => '578008VCL03', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '125910', 'instructorSfId' => 'a0237000001Y4T7AAK', 'instructorDisplayName' => 'Erick Polsky', 'instructorName' => 'Erick Polsky', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '1', ))
Live, Online Training
Jun 13th - 15th
10:00 AM - 6:00 PM ET
$1795(usd)
Guaranteed to RunGuaranteed to Run
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9gQAD', 'startDate' => '2022-07-06', 'startTime' => '8:30 AM', 'endDate' => '2022-07-08', 'endTime' => '4:30 PM', 'name' => '578009VCL', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Jul 6th - 8th
8:30 AM - 4:30 PM ET
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9hQAD', 'startDate' => '2022-08-15', 'startTime' => '9:00 AM', 'endDate' => '2022-08-17', 'endTime' => '5:00 PM', 'name' => '578009VCL02', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Aug 15th - 17th
9:00 AM - 5:00 PM ET
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9iQAD', 'startDate' => '2022-09-24', 'startTime' => '10:00 AM', 'endDate' => '2022-09-26', 'endTime' => '6:00 PM', 'name' => '578009VCL03', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Sep 24th - 26th
10:00 AM - 6:00 PM ET
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIsIZQA1', 'startDate' => '2022-09-26', 'startTime' => '9:00 AM', 'endDate' => '2022-09-28', 'endTime' => '5:00 PM', 'name' => '578009CLT', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'CLT', 'sessionStatus' => 'O', 'city' => 'Charlotte, NC', 'state' => 'NC', 'cityState' => 'Charlotte, NC', 'locationSfId' => 'a0637000000tn87AAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Please call Cprime for location details
at 1-877-800-5221
Charlotte, NC', 'gtr' => '', ))
Charlotte, NC
Sep 26th - 28th
9:00 AM - 5:00 PM Local Time
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9jQAD', 'startDate' => '2022-10-05', 'startTime' => '12:00 PM', 'endDate' => '2022-10-07', 'endTime' => '8:00 PM', 'name' => '578010VCL', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Oct 5th - 7th
12:00 PM - 8:00 PM ET
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIsIaQAL', 'startDate' => '2022-10-05', 'startTime' => '9:00 AM', 'endDate' => '2022-10-07', 'endTime' => '5:00 PM', 'name' => '578010SND', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'SND', 'sessionStatus' => 'O', 'city' => 'San Diego, CA', 'state' => 'CA', 'cityState' => 'San Diego, CA', 'locationSfId' => 'a0637000000tn54AAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Please call Cprime for location details
at 1-877-800-5221
San Diego, CA 92101', 'gtr' => '', ))
San Diego, CA
Oct 5th - 7th
9:00 AM - 5:00 PM Local Time
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9kQAD', 'startDate' => '2022-11-21', 'startTime' => '8:30 AM', 'endDate' => '2022-11-23', 'endTime' => '4:30 PM', 'name' => '578010VCL02', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Nov 21st - 23rd
8:30 AM - 4:30 PM ET
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIsIbQAL', 'startDate' => '2022-11-30', 'startTime' => '9:00 AM', 'endDate' => '2022-12-02', 'endTime' => '5:00 PM', 'name' => '578010DAL', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'DAL', 'sessionStatus' => 'O', 'city' => 'Dallas, TX', 'state' => 'TX', 'cityState' => 'Dallas, TX', 'locationSfId' => 'a0637000000tn6GAAQ', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Please call Cprime for location details
at 1-877-800-5221
Dallas, TX 75201', 'gtr' => '', ))
Dallas, TX
Nov 30th - Dec 2nd
9:00 AM - 5:00 PM Local Time
$1795(usd)
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000ZIs9lQAD', 'startDate' => '2022-12-07', 'startTime' => '10:00 AM', 'endDate' => '2022-12-09', 'endTime' => '6:00 PM', 'name' => '578010VCL03', 'standardCourseFee' => '1795', 'standardCourseFeeCAD' => '2350', 'standardCourseFeeEUR' => '1650', 'courseId' => 'POWERBIDAX', 'course' => 'a001G00000FC1UKQA1', 'courseSfId' => 'a001G00000FC1UKQA1', 'courseName' => 'Mastering DAX for Microsoft Power BI', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Dec 7th - 9th
10:00 AM - 6:00 PM ET
$1795(usd)
Register

Request Private Group Training