Forum Discussion

prabhupan's avatar
prabhupan
Icon for Helper I rankHelper I
9 years ago
Solved

issue with relationship between tables

Hello, 

 

I have an active relationship between 2 tables, table 1 & 2.

 

However when i try to have a New Column in table 2 by using "RELATED"  function, it never shows table 1 and i couldnt pick the corresponding value from table 1. 

 

Any comment on how to solve this ?

 

Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    prabhupan

     

    RELATED function can only be used in the many side. Just think if we use it in the one side, there will be multiple values related to a single value, which one should be returned in only one cell?

     

    Best Regards,

    Herbert

5 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    prabhupan

     

    Is the relationship ‘many to one’ or ‘one to one’? If it is ‘many to one’, did you create the related column in the ‘many’ side?

    I tried on Feb 2017 version of Power BI Desktop but cannot repro the same issue as you.

     

     

    Best Regards,

    Herbert

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    prabhupan

     

    RELATED function can only be used in the many side. Just think if we use it in the one side, there will be multiple values related to a single value, which one should be returned in only one cell?

     

    Best Regards,

    Herbert