Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
How can I merge 2 tables that have different structure?
I would like to merge to a table called "Lines" the months from table "Months & units"
In this case the table lines should go from this:
To this:
As seen, each of the 3 products or row, were assigned all the available months. So, column F "month" highlighted in light blue is the result desired.
The months as mentioned come from table "Months & units" but I also added on power bi a month table with its unique values called "month catalog"
How can I get the months merged to my table "lines"?
pbix and excel are attached:
https://1drv.ms/u/s!ApgeWwGTKtFdhni9c6kuDioLhq0H?e=SvaW8g
Thanks!
Solved! Go to Solution.
Hi,
See the Lines table of this file.
Hope this helps.
Hi,
See the Lines table of this file.
Hope this helps.
Hi,
Save the Excel file on your desktop. Double click on Source and link to the Excel file on your desktop.
You can do a table merge on more than one column. Select all the common columns from both tables during the dialog.
Another way is to use a custom combiner function for Table.AddColumn .
Hi @lbendlin
And how to I merge both? From table "Month Catalog" or "Month & Units" to table "lines" by using Power Query.
Thanks.
For example:
let
Source = Table.NestedJoin(Lines, {"Country", "Plant", "Line"}, #"Months & Units", {"Country", "Plant", "Line"}, "Months & Units", JoinKind.Inner)
in
Source
Hi @lbendlin
I want to my table lines, opened the editor and did this:
But got an error, reading your code, where is it bringing the months to the table lines?
Thanks.
You need to put my code in a new, blank query
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |