Forum Discussion
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 - the data is coming as expected.
Now I need to do some transformation, when I open Power Query Editor - the column is not visible there - is there any limitation ? If so how I can perform the same lookup function within Power Query Editor ?
Thanks.
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
14 Replies
- mahoneypat
Microsoft Employee
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
- parry2k
Super User
Anonymous 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.⚡
