View Catalog

Use Advanced Calculations With DAX Formulas

ID: 54325
Topics: Technology
NON-MEMBERS$160.00
MEMBERS$140.00
YOUR PRICE$160.00

This course focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas. You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. 

Learning Objectives: 

Create calculations using DAX formulas 

Use a Date / Calendar table to perform complex date analysis 

Use the DAX calculation process to validate calculations

Speakers

Bryan Smith
Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.