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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.