Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

RELATED function not working in one to many relationship

HI ALL

 

I have two Tables  Registration Table and Interview Result Table. 

 

I want to create two columns (Final Status, Interview Completed?) in the Registration Table by using Interview Result Table value

 

How can I achieve this logic?

 

Registration Table:

 

Candidate ID Name Phone

1A5555555
2B6666666
3C7777777
4D888888
5E999999

 

Interview Result Table :

 

Candidate ID Interview Round Status Final Status

1Tech 1SelectedSelected
1Tech 2SelectedSelected
1HRSelectedSelected
1FinalSelectedSelected
2Tech 1SelectedRejected
2Tech 2SelectedRejected
2HRSelectedRejected
2FinalRejectedRejected
3Tech 1SelectedHold
3Tech 2SelectedHold
3HRHoldHold

 

Final Result:

 

Candidate ID Name Phone Final Status Interview Completed?

1A5555555SelectedYes
2B6666666RejectedYes
3C7777777RejectedYes
4D888888 No
5E999999 No
1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE

Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Interview Result'),"Status",[Final Status]),TRUE())


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

3 REPLIES 3
JoelN
Helper I
Helper I

Nicely done @Stachu 👍

Iryna
New Member

Hello,

In my case it doesn't work 😞 Or I do something wrong. I have just started working with Power BI.
I would like do do a kind of VLOOKUP in order to assingn values from the table "one" to the table "many". So the values will be repeating in the new column of the table "many".

 

Thanks,
Iryna

Stachu
Community Champion
Community Champion

RELATED works only for side 1 of the relationship, for side many you need to use RELATEDTABLE

Column = LASTNONBLANK(SELECTCOLUMNS(RELATEDTABLE('Interview Result'),"Status",[Final Status]),TRUE())


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.