Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New column not visible in Power Query Editor

Hello Folks,   I have created a new column named "Executive Director" in Power BI desktop, in this new column, I am getting data from another table named "systemusers" using LOOKUPVALUE function - ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Here is the way to LookupValue on Power Query Editor:

     

    Menu Add Column > Custom Column = Table.SelectRows(systemusers, each Text.Contains([ownerid],[cr6d3_companyceo]))

     

    credit: https://www.powerquery.io/table/table.selectrows

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous you can use merge in PQ

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k I checked the possibility of merging however the second table contains list of Users which comes from a LDAP hence a heavy one - so taking in consideration your recommendations I will keep this as a last option.

 

As both table contains a relationships, would it be possible to add a new column in joining both tables ?

 

Is this possible in PQ ? If so can you show me please.

 

Thanks.