Merge operations in Power Query (in Power BI or in Excel)
Dear all,
Greetings, here're are a couple ways by which one could merge data in Power Query in either Power BI or in Excel.
a. When we have a defined common columns (primary and foreign keys) in your tables.
b. Using fuzzy lookup when the data does not have a primary/foreign key and so we have to rely on almost common names between 2 sets of data.
Kind regards,
Sanjiv
