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

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k Yes, you are right - I have added the column using DAX.

 

I tried to perform the same steps in PQ however I could not find any pre-built function like LOOKUPValue or I am doing something wrong there ?

 

Can you help me there or share some resources if handy.

 

Thanks

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.

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

      Anonymous let's go back to the actual problem and explain what you are trying to do. Answer to your original question was already provided and I think it is better to look at the problem. Explain the problem with sample data and expected output and it will save time.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k Sure.

         

        In my mainTable, I am getting the GUID of the user which has submitted the data.

         

        The User Details (Name, Email, etc) are stored in another table named SystemUsers.

         

        Using DAX, to get the value of these users - I have simply used the following formula which works fine.

        Newcolumn = LOOKUPValue(systemusers[fullname],systemusers[ownerid],mainTable[cr6d3_companyceo])

         

        My challenge is to do the same in PQ.

         

        Thanks and regards.