0
0
Power BIbi_tool~10 mins

RELATED for cross-table values in Power BI - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Sales table records quantities sold by ProductID. Products table lists ProductID and ProductName.

CellValue
Sales[ProductID]101
Sales[Quantity]5
Sales[ProductID]102
Sales[Quantity]3
Products[ProductID]101
Products[ProductName]Pen
Products[ProductID]102
Products[ProductName]Notebook
Formula Trace
RELATED(Products[ProductName])
Step 1: RELATED(Products[ProductName]) for Sales[ProductID] = 101
Step 2: RELATED(Products[ProductName]) for Sales[ProductID] = 102
Cell Reference Map
Sales Table       Products Table
+------------+   +------------+------------+
| ProductID  |   | ProductID  | ProductName |
| 101        |   | 101        | Pen        |
| 102        |   | 102        | Notebook   |
+------------+   +------------+------------+
      |                     |
      +--------RELATED-------+
RELATED uses Sales[ProductID] to look up Products[ProductID] and fetch Products[ProductName].
Result
+------------+----------+--------------+
| ProductID  | Quantity | ProductName  |
+------------+----------+--------------+
| 101        | 5        | Pen          |
| 102        | 3        | Notebook     |
+------------+----------+--------------+
The Sales table now shows ProductName from the related Products table using RELATED function.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does RELATED(Products[ProductName]) return for Sales[ProductID] = 101?
APen
BNotebook
C101
D5
Key Result
RELATED(column) fetches a value from a related table using the current row's key.