Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |