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 not sure how this post is relevant to the other one. I think you are over complicating everything. Maybe it is better to share sample data in excel with the expected output.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k Then ignore the last reply.

 

The requirement as of now is to lookup the value in another table - as we now using DAX its simple - how to achieve the same in Power Query ? I dont think so its that complicated.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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