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 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.

     

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

      Anonymous you don't need to do anything in PQ or lookup assuming you have a relationship between these two tables and systems users is on the one side of one to many or one to one relationship and if that is the case, add column in your data table as below

       

      Full Name = RELATED ( systemsusers[FullName] )

       

      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 As I explained above, I cannot use the column added in DAX in PQ 😞