Forum Discussion
Solved
create a custom column from information from a column in another table
Hello,
I would like in Power Bi to create a custom column on Power query in Table 1 using the column "Salary" of Table 2 if Table1.Classes = Table2.Classes.
| TABLE 1 | |
| Members | Classes |
| Rim | C1 |
| Moussa | C2 |
| Thierry | C3 |
| Jones | C4 |
| TABLE 2 | |
| Classes | Salary |
| C1 | 1000$ |
| C2 | 2000$ |
| C3 | 3000$ |
| C4 | 4000$ |
| C6 | 6000$ |
| C7 | 7000$ |
| C8 | 8000$ |
This is the result i would like to have in Power Query
| TABLE 1 | ||
| Members | Classes | Salary |
| Rim | C1 | 1000$ |
| Moussa | C2 | 2000$ |
| Thierry | C3 | 3000$ |
| Jones | C4 | 4000$ |
Can you please help me do this?
Thank you.
Hi Rena13M ,
You can do this with Merge Queries:
Here is some additional information:
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
1 Reply
- djurecic
Super User
Hi Rena13M ,
You can do this with Merge Queries:
Here is some additional information:
https://radacad.com/append-vs-merge-in-power-bi-and-power-query