Brian Smith, CPA Crossings


    Credit Info
  • NASBA Field of Study

  • Format

    On demand

  • Level

  • CPE Credit


  • Course acronym

  • Prerequisites

  • Course duration

    4 Hours

Microsoft Power BI – Use Advanced Calculations with DAX Formulas

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.
Hurry up, special offer for a limited time only.
Topics discussed

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

Learning objectives

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

Who will it benefit?

Anyone who is using Power Pivot or Power BI Desktop for data analysis