Forum Discussion

Mon_Go27's avatar
Mon_Go27
Frequent Visitor
3 years ago
Solved

LOOKUPVALUE not retrieving all the values

 Hi, I have two tables. KEYWORD REFERENCE table has a list of abbreviations (unique values) that are classified into different types. KEYWORDS table has a list of users that have been assigned one or...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Mon_Go27 

     

    Download example PBIX file

     

    Why do you need to create a column in the Keywords table?  If you have a relationship between the two tables then the Type can be shown in a table visual when displaying the UID and Abbreviation from the Keyworsd table - see attached file.

     

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

Hi Mon_Go27 

 

Download example PBIX file

 

Why do you need to create a column in the Keywords table?  If you have a relationship between the two tables then the Type can be shown in a table visual when displaying the UID and Abbreviation from the Keyworsd table - see attached file.

 

 

regards

 

Phil

  • Mon_Go27's avatar
    Mon_Go27
    Frequent Visitor
    3 years ago

    Hi Phil,

     

    Thank you!

     

    You're right. I guess I was so focused on making it work that I forgot I was able to do it that way.

     

    I will do it like that. Thanks again! 🙂