Simple play icon Course
Skills

Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS

by Eugene Meidinger

DAX is a popular language for any sort of analytical reporting in the Microsoft BI stack. Whether you are using Power BI, Power Pivot, or SSAS, this course will teach you how to model your data with DAX.

Start FREE course Preview this course

What you'll learn

If you want to use Power BI, Power Pivot, or SSAS (tabular mode), you'll need to learn DAX. In this course, Getting Started with DAX Formulas in Power BI, Power Pivot, and SSAS, you'll learn the basics of the DAX language. First, you'll learn how DAX works and why it has such good performance. Next, you'll explore how to encapsulate business logic using calculated columns and measures. Finally, you'll discover a variety of ways to manipulate filters or analyze your data. When you're finished this course, you'll have the skills and knowledge of DAX to model and analyze your data with the DAX expression language.

Table of contents

Course Overview
1min
Understanding What Makes DAX so Unique
14mins
Planning Your Data Governance: Power BI, Power Pivot, or SSAS Tabular?
18mins
Thinking in Columns, Not Rows
29mins
Adding Business Logic with Calculated Columns and Measures
29mins
Filtering Data Using CALCULATE
27mins
Looping Over Data with Iterators
30mins
Analyzing History with Time Intelligence
26mins

About the author

Eugene Meidinger

Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

See more courses by Eugene Meidinger
Ready to upskill? Get started