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 let's go back to the actual problem and explain what you are trying to do. Answer to your original question was already provided and I think it is better to look at the problem. Explain the problem with sample data and expected output and it will save time.
parry2k Sure.
In my mainTable, I am getting the GUID of the user which has submitted the data.
The User Details (Name, Email, etc) are stored in another table named SystemUsers.
Using DAX, to get the value of these users - I have simply used the following formula which works fine.
Newcolumn = LOOKUPValue(systemusers[fullname],systemusers[ownerid],mainTable[cr6d3_companyceo])
My challenge is to do the same in PQ.
Thanks and regards.
- parry2k
Anonymous 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 😞
- 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?