microsoft partner logo color
8340  Reviews star_rate star_rate star_rate star_rate star_half

Power BI DAX Formulas and Functions

DAX is the language for writing formulas in Power BI to perform complex calculations and create dynamic visualizations that would not be possible using Power BI alone. Ascendient Learning's DAX for...

Read More
By Request
$219 USD
Duration 4 hours
Course Code PBI-123
Available Formats Classroom

Overview

DAX is the language for writing formulas in Power BI to perform complex calculations and create dynamic visualizations that would not be possible using Power BI alone. Ascendient Learning's DAX for Power BI training course teaches attendees how to write formulas and functions in Power BI using DAX, create measures, and use the formula bar.

Skills Gained

  • Understand DAX fundamentals
  • Create calculated columns, calculated tables, and measures using DAX
  • Apply essential DAX functions to solve common business problems
  • Work with date and time functions in DAX
  • Use DAX count functions to summarize data

Prerequisites

All attendees must understand the basics of using Power BI and creating reports.

Course Details

Training Materials

All Power BI training students receive comprehensive courseware.

Software Requirements

  • A recent version of Windows (Windows 10 or later) with at least 8 GB of RAM
  • Microsoft Office installed (especially Excel)
  • Power BI Desktop installed

Outline

  • Introduction to DAX
    • What is DAX?
    • Creating Calculations without DAX
    • Understanding Measures
    • Understanding Quick Measures
    • Using the Formula Bar
  • Essential DAX Functions Every User Should Know
    • SUM() & SUMX()
    • AVERAGE() & AVERAGEX()
    • MIN() & MINX()
    • MAX() & MAXX()
    • CALCULATE()
    • FILTER()
    • ALL()
    • RELATED()
    • TOTALYTD(), TOTALQTD(), TOTALMTD()
    • CONCATENATE() & CONCATENATEX()
    • SWITCH()
  • DAX Date and Time Functions
    • DAY(), MONTH(), QUARTER(), YEAR()
    • TODAY(), NOW(), NETWORKDAYS()
    • DATEDIFF()
    • EDATE()
    • EOMONTH()
    • Other Date Functions
  • DAX Count Functions
    • COUNT()
    • COUNTA()
    • COUNTBLANK()
    • COUNTROWS()
    • DISTINCTCOUNT() & DISTINCTCOUNTNOBLANK()
  • Conclusion
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

The class and material is good. I think some of the software needs to be updated.

great class and packed with material, would have lived to spread it more into many days but overall very informative.

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.

I thought the course was informative and the tools to go over the material were very nice.

Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.