From the course: Power BI Top Skills
Join today to access over 24,600 courses taught by industry experts.
Introduction to DAX - Power BI Tutorial
From the course: Power BI Top Skills
Introduction to DAX
- Data analysis expressions is a formula expression language used in Power BI desktop and Power Pivot in Excel. DAX enables you to create custom views of the data. This is a very important mechanism to have a handle on when you're building out your data visualizations. Now, DAX formulas include functions and operators, but for the purposes of Power BI, they're really only two key ways you need to know about using DAX, calculated columns and measures. Calculated columns help you generate new formula based columns. These columns understand row context and are immune to filter contexts. This means that when you create a filter on a dashboard your calculated columns will remain untouched. Measures are a dynamic calculation formula where the results change depending on the context. Measures are used in reporting and support combining and filtering model data by using multiple attributes. Commonly used measures include average…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.