Forum Discussion
Creating column based on another column in a deferent table
Hi,
I have a column called "Project Number" in a "table A" and would want additional fields to be created in "Table A" based on the "Project Number" field of another column.
For example "Project Number, Location, PM and Divisional Lead" is on Table B. I would like to add "Location, PM and Divisional Lead" fields to To "Table A" if the value of the Project Number is the same.
I need to append it to a master table. With the Dax function or colums added in "Data" is not showing when "Transform Data" stage.
Please let me know if you need more clarification
4 Replies
Anonymous , One way is to use merge in power Query and get those columns.(all can be moved)
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Another way is to create dax column for those.( One by one) :https://www.youtube.com/watch?v=czNHt7UXIe8
refer my video for that
If the tables are Joined together, REALTED is an easy way. If they aren't joined together, or you need more control over the serach logic, LOOKUPVALUE is very useful, but takes more processing time to run.
See this artile with example to help:
https://www.sumproduct.com/blog/article/power-pivot-principles/ppp-related-vs-lookupvalue
Hi Anonymous ,
Any column created by dax will not show in query editor. Before you append it to a master table, you can merge tableA with tableB by Project Number column. Please follow the steps in https://businessintelligist.com/2015/09/15/power-bi-desktop-merge-query-options/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
