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