Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables, both have 1 common column that can be linked to each other.
Example:
Table 1 Columns: Item, Date of Purchase, Customer, Item ID
Table 2 Column: Item ID, Price, Effective Date
How do I create a query, such that I add 1 column from the 2nd table to the 1st table? Kind of like a VLOOKUP in excel.
Example here: is to add price (from table 2) into Table 1.
Thank you.
Solved! Go to Solution.
you can add a new column in Table1 with the code below:
Price2 = RELATED(Table2[Price])
or you want a query for a complete new table, try to create a new table with this:
Table3 =
ADDCOLUMNS(
Table2,
"Price2",
RELATED(Table2[Price])
)
you can add a new column in Table1 with the code below:
Price2 = RELATED(Table2[Price])
or you want a query for a complete new table, try to create a new table with this:
Table3 =
ADDCOLUMNS(
Table2,
"Price2",
RELATED(Table2[Price])
)
Hi @BAFreedom
In case you want to use DAX, watch this video
https://www.youtube.com/watch?v=6_O3UDKOVHo&t=3s
But if you want to use Power Query Editor to merge Columns and/or tables
https://www.youtube.com/watch?v=y3bOyNpJuXc
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |