From the course: Power BI Top Skills

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

DAX

DAX - Power BI Tutorial

From the course: Power BI Top Skills

Start my 1-month free trial Buy for my team

DAX

“

- Power BI uses a formula expression language called DAX. DAX is short for Data Analysis Expressions, and it's a library of functions and operators that allow you to create formulas and expressions in Power BI. Now, DAX is pretty complex. It includes formulas, operators, measures, queries data types, and much, much more, but there are really two main concepts that you need to understand about this language. The first concept is how to create calculated columns in DAX. This skill will allow you to better understand how two fields are related. For example, one of my clients sells items in all 50 states but within each state, there are multiple stores. They're very interested in seeing the average store velocity, or in other words, the average sales per store in different states. To get this figure, I created a calculated column that divides the sum of sales by state by the total store count. The next concept that you…

Contents