How do I merge two tables in Power Query? What are the various options for merging two tables in Power Query/BI?

To combine two tables in Power Query, the ‘Merge Query’ feature is utilized.
Steps:

1. Home tab, Under which clicks Transform Data thereby opening Power Query Editor.
2. Choose the query you want to merge.
3. On the Home tab, within the Combine group, click Merge Queries. Two options are Merge Queries and Merge Queries as New.
4. In the dialog box for Merge Queries, choose tables to be merged.
5. Choose now the columns in each of the tables to merge them. If you want to choose more than one, then press Ctrl + Click for selection.
6. Select Join Type (Left, Right, Inner, Full).
7. Click OK.
8. Second Table will get joined and added as a column to the First Table.
9. Click on the down arrow next to the Column Name of the newly added column.
10. Choose the columns you wish to add.
11. Click OK.