We're related

Complete this exercise on DataCamp in in-browser Excel, or locally on your computer if you have Excel and Copilot.

RELATED() is a powerful relationship function in DAX that allows Power Pivot to reference columns in other tables. This is very similar to a VLOOKUP() in Excel: you have one column from one data table or range, and you retrieve a value from another column based on a matching key. In Power Pivot, since we've already established relationships between tables in our data model on a matching key, we can use RELATED() to reference columns in other related tables.

Let's bring in some fields so we can explore more aspects of our loan_data table. We could bring in the banker and closing month to find the number of closings by banker, which could be interesting to know.

Continue working in your current workbook. If you've lost progress, open 3_1_equity.xlsx from the Workbooks folder in the course materials.