cancel
Showing results 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

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

 1 A 5555555 2 B 6666666 3 C 7777777 4 D 888888 5 E 999999

Interview Result Table :

Candidate ID Interview Round Status Final Status

 1 Tech 1 Selected Selected 1 Tech 2 Selected Selected 1 HR Selected Selected 1 Final Selected Selected 2 Tech 1 Selected Rejected 2 Tech 2 Selected Rejected 2 HR Selected Rejected 2 Final Rejected Rejected 3 Tech 1 Selected Hold 3 Tech 2 Selected Hold 3 HR Hold Hold

Final Result:

Candidate ID Name Phone Final Status Interview Completed?

 1 A 5555555 Selected Yes 2 B 6666666 Rejected Yes 3 C 7777777 Rejected Yes 4 D 888888 No 5 E 999999 No
1 ACCEPTED SOLUTION
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())`

Thank you for the kudos 🙂

3 REPLIES 3
Helper I

Nicely done @Stachu 👍

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

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())`

Thank you for the kudos 🙂

Announcements

#### 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 Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors