From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

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

Create basic DAX expressions

Create basic DAX expressions - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Create basic DAX expressions

“

In this sub-lesson, we're going to define and discuss three types of DAS expressions, Calculated Columns, Measures, and we'll introduce Calculated Tables. First off, we will discuss Calculated Columns. Calculated Columns are calculated on a row-by-row basis, and they create a new physical column in your model. they do take up space in your data model, and the value is calculated at data load time. They typically reside in dimension tables to be used as labels on reports and or slicers, and they can often be pushed into the Power Query engine. So below is an example of a calculated column. And calculated columns, as mentioned on the previous slide, use something called the row context. The row context is applied as a virtual pointer which moves down a table of data row by row and is used in a calculation. So let's go over to the Power BI Desktop and show an example of building a calculated column and how the row context works. Okay, so I am over on my Power BI Desktop. And what I'm…

Contents