Power BI DAX’s RELATED vs RELATEDTABLE Function
What’s the difference and when to use them.
Not a Medium member? Access premium content for free on my website:
Today, let’s talk about the RELATED and RELATEDTABLE functions. These functions are used to access data from related tables in your data model. If you have worked with any databases or BI tools, you must have created relationships between tables to form a snowflake schema or star schema. Power BI is really efficient when you create a data model by following star schema.
Now, let’s understand what RELATED and RELATEDTABLE functions are and how can you utilize them in your next Power BI project. You can use the RELATED function to retrieve a single value from a related table based on the current row context. If you are familiar with LOOKUP in Excel, RELATED works exactly the same. For example, if you are looking to get a salesperson’s information such as a name from the Employee table to the Sales table to see their sales amount side by side. it will return a blank value if there is no matching row in the related table or if there are…