From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

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

Join data with RELATED

Join data with RELATED - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Join data with RELATED

“

All right. Next up, let's talk about the RELATED function. Now, RELATED returns related values in each row of a table based on its relationships with other tables in the model. So the syntax is incredibly easy. You just point it to a column reference, and that's the column that contains the values you're trying to retrieve. So important note here, RELATED works almost exactly like a VLOOKUP. It uses those relationships between tables to basically reach into one table and retrieve values, and pull them back into the column of another table. And since this function requires row context, you can only use it as either calculated column or as part of an iterator function that cycles through tables row-by-row. So we talked about how FILTER was one example of that. And in the next video, we're going to be talking about X functions like SUMX, MAXX, COUNTX, and more. So quick pro tip here: you might be tempted to use the RELATED function because it's easy and because it's kind of nice and…

Contents