Table.Join
The function combines the rows of table1 with the rows of table2 by matching the values of the key columns specified by key1 (for table1) and key2 (for table2). By default, it performs an inner join, ...
Table.Join(table1 as table, key1 as any, table2 as table, key2 as any, optional joinKind as nullable number, optional joinAlgorithm as nullable number, optional keyEqualityComparers as nullable list) as tableThe function combines the rows of table1 with the rows of table2 by matching the values of the key columns specified by key1 (for table1) and key2 (for table2). By default, it performs an inner join, but you can also specify a joinKind parameter to indicate the type of join you want to perform. The options available are: InnerJoinKind, LeftOuterJoinKind, RightOuterJoinKind, FullOuterJoinKind, LeftAntiJoinKind, RightAntiJoinKind. Additionally, a set of keyEqualityComparers can be included to define how the key columns should be compared. This feature is currently designed for internal use only.
To merge two tables based on a common key column, the Power Query MTable.Join function can be used. First, create the two tables with the required data entries, including CustomerID, Name, Phone, OrderID, Item, and Price. Then, use the MTable.Join function to merge the tables based on the "CustomerID" key column. The output will be a new table that combines the information from both tables, showing CustomerID, Name, Phone, OrderID, Item, and Price for each merged entry.