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 if you added the column using DAX (seems like you did) , it will not show up in Power Query. You have to add the column in PQ.
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 Yes, you are right - I have added the column using DAX.
I tried to perform the same steps in PQ however I could not find any pre-built function like LOOKUPValue or I am doing something wrong there ?
Can you help me there or share some resources if handy.
Thanks
- parry2k
Anonymous you can use merge in PQ
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 I checked the possibility of merging however the second table contains list of Users which comes from a LDAP hence a heavy one - so taking in consideration your recommendations I will keep this as a last option.
As both table contains a relationships, would it be possible to add a new column in joining both tables ?
Is this possible in PQ ? If so can you show me please.
Thanks.
- parry2k
Anonymous 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.