Power BI has a RELATED function that allows you to get data from a related table. Let’s go through an example.
We have 2 tables:
- Goals, which holds salesperson’s goals
- Sales, which holds sales transactions
The tables have a relationship of the common field Salesperson.
Now, let’s say we want a field in the Sales table which is the Goal field from the Goals table. To do this, create a new Calculated Column:
Then, add the RELATED formula below. When you start typing, Power BI will display the possible fields based on the relationship.
Now, we will drag this new calculated column onto our report. You can see, the new calculated column contains data from the Goal field.
I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.
IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.
THANK YOU, AND LET'S KEEP LEARNING TOGETHER.
CARL
