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