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

     

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

DAX calculated columns are updated after the query is loaded, so you won't see those columns there.  The simplest way to do it in the query editor is to Merge the two tables on your LOOKUP column and expand just that field.  Depending on how big your data set is, FYI that adding merge steps can significantly increase refresh times (but try it and see if it is acceptable).

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat