Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    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())
Iryna's avatar
Iryna
New Member
6 years ago

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