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.
I have the following data with me already.
Table 1 Consists of Column A , Column B , Column C
Table 2 Consists of Column D , Column E
Now i want to create a new table as
Table 3 Consists of Column A , Column D.
Note: Column A is of data type Text and Column D is of Data type Decimal Number.
Any help, suggestion on this will be of great help
Solved! Go to Solution.
Hi @Anonymous ,
At first, you need to add an index column( start from 0 ) in the first table.
Then add a custom column like the following codes:
=Table.AddColumn(#"Added Index", "Column4", each TableB{[Index]}[Column4])
Hi @Anonymous ,
At first, you need to add an index column( start from 0 ) in the first table.
Then add a custom column like the following codes:
=Table.AddColumn(#"Added Index", "Column4", each TableB{[Index]}[Column4])
Do you have any IDs in your tables that should be used to match rows between tables? If yes, then merge the tables https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616...
Or do you have two tables with no IDs but with the same number of rows in each table and want to merge them as is (row 1 with row 1, row 10 with row 10, last row with last row)? Add Index column to both tables https://support.microsoft.com/en-us/office/insert-a-custom-column-into-a-table-power-query-2dbb579a-... and then merge two tables by index columns.
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.