Skip to main content

Welcome to the all-new FICPA.org. If you have not logged into our new site (launched Sept. 24), you will need to reset and create a new password.

We are transitioning to a new phone system on Friday afternoon, but please send any questions or concerns to msc@ficpa.org, and we will respond to your message as soon as possible.

Microsoft Power BI - Use Advanced Calculations with DAX Formulas

Available Until

**Online**

4.0 Credits

Member Price $89.00

Non-Member Price $109.00

Overview

Use Data Analysis Expressions (DAX) to create advanced calculations!

This is the seventh course in the Microsoft Power BI series. This course focuses on using DAX (Data Analysis Expressions) to create advanced calculations in Power Pivot data models. You will learn over 20 DAX functions that will allow you to perform calculations not possible with standard Excel. Use of a date or calendar table will be reviewed.

The course is presented using Excel 2019/Office 365. Regardless of the version you are using,most concepts covered in this course apply to all versions of Excel.

This self-study online course is part of the Microsoft Power BI: Power BI Series.

Highlights

Key Topics

  • Power Pivot calculations (column calculations versus measures)
  • Advanced DAX formulas
  • Date/calendar tables
  • DAX calculation process

Prerequisites

Attended the Power Pivot or Power BI Desktop class or equivalent

Objectives

Learning Outcomes

  • Create calculations using DAX formulas.
  • Use date/calendar tables to perform complex data analysis.
  • Use the DAX calculation process to validate calculations .

Non-Member Price $109.00

Member Price $89.00

Add to Cart