Forum Discussion

prabhupan's avatar
prabhupan
Helper I
9 years ago

Indirect relationship between table

  Hello,    I have 3 tables as given below.  Table 3 is the user info table.    I now need to get the Manager name based on the Manager Id in table2. However, i cannot create a relationship betw...
Need Help
prabhupan's avatar
prabhupan
Helper I
9 years ago

hello Phil_Seamark,

 

Doesnt seems so. Please see the image below... in some cases you get the name (first column) & for some its blank. (the manager id is in second column)

 

 

 

 

 

 

sankarvinop's avatar
sankarvinop
Frequent Visitor
9 years ago

Hi ,

Try this, 

Manager Name = if( COUNTROWS(Assigment)=1, LOOKUPVALUE(User[Name],User[ID],VALUES(Assigment[Managere ID])))

 

Thanks 

Sankar P

 

  • prabhupan's avatar
    prabhupan
    Helper I
    9 years ago

    Hello sankarvinop,

     

    It doesnt work since table2 has more that 1 rows, so :

     

    COUNTROWS(Assigment)=1 is always false 

     

    • sankarvinop's avatar
      sankarvinop
      Frequent Visitor
      9 years ago

      Hi,

      Can you share some sample data?