Microsoft Power BI - Use Advanced Calculations with DAX Formulas
Available Anytime
Location:
Online
4Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$109.00 Regular Price
Product Code: AI23-PWRBI7
Level: Overview
Vendor: AICPA CPE Division
Field of Study: Computer Software and Applications
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.
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 .
Major Topics:
Key Topics
- Power Pivot calculations (column calculations versus measures)
- Advanced DAX formulas
- Date/calendar tables
- DAX calculation process