Forum Discussion
Join two tables via a common variable
Hi, I am trying to append 2 tables by tying the 2 together by the Employee ID column. I am new to Power BI, am I doing something wrong? I want the Gender and Level information (pic1) to be added...
Hey,
you can achieve what you are looking for by "merging" columns from one table into the other.
This Blogpost explains it very good, I think:
http://radacad.com/append-vs-merge-in-power-bi-and-power-queryHopefully this gets you started.
Regards,
Tom
TomMartens
Super User
Super UserHey,
you can achieve what you are looking for by "merging" columns from one table into the other.
This Blogpost explains it very good, I think:
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hopefully this gets you started.
Regards,
Tom
Awesome! Thank you very much. The merge worked perfectly!