Forum Discussion
Solved
Display/insert data from one table into another
Hello, I have two tables; the "Employees" table and the "Additional Information" table. I now want to copy from the "Additional Information" table the values from the fields "Company", "Contract" an...
I have solved it now with "CONCATENATE" (the Employee ID, Year and Month) and then with "LOOKUPVALUE". And it works 🙂
GeorgW , You can merge in power Query and keep the required columns
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Video: https://www.youtube.com/watch?v=zNrmbagO0Oo
Dax you can do column by column: https://www.youtube.com/watch?v=czNHt7UXIe8
Thank you very much. But that is - I think - not the solution. I have presented the two tables in a very simplified way; they are already combined tables with much more information, so another combination won't work. Besides, I have several "key columns" (employee ID, year AND month). Can't I solve it with a formula?