Forum Discussion
New column not visible in Power Query Editor
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
Super UserAnonymous 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.⚡
parry2k As I explained above, I cannot use the column added in DAX in PQ 😞
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
Anonymous but why it matters that column has to be added in PQ. This is the most effective and best practice solution. Merging and lookup are costly functions. I don't get the point that this column needs to be in PQ, what is the importance of that? Please explain?
parry2k sure,
1: I need to parse that column to show the user details in the reports (Full Name, Email)
2: Afterwards, I need to transform the data to show up the Company Name as a column.
(you and Harsh already helped me in the same yesterday: see https://community.powerbi.com/t5/Desktop/How-to-sum-columns-horizontally-and-dynamically/m-p/1187289#M533108)
- parry2k
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.
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.