Forum Discussion
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...
hello Phil_Seamark,
i tried LOOKUPVALUE as follows:
- LOOKUPVALUE(TABLE3[Name],TABLE3[Id],TABLE2[ManagerId]). But it retruns blank mostly. :smileysad:
Is that because there is no match?
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)
