BI Simplified webinar#1, p4: Merge Queries

VLOOKUP (and now XLOOKUP) is one of the most popular functions in Excel. And we primarily use it to combine two tables. And most of us can agree that it takes time to get the hang of this formula. With Power Query, we can simplify this process using a feature called Merge Queries. It is equivalent to SQL JOINS. And Power Query offers six types of JOINS, which are simple to apply.




Related article:

VLOOKUP & JOINS using Power Query

Self Join in Power Query


Join the group BI Simplified to stay updated on future webinars and articles.

@imvivran

Drop Me a Line, Let Me Know What You Think

 

contact@vivran.in

+91 9871-641-146

Join WhatsApp group: BI Simplified

MS EXCEL || POWER BI || POWER APPS || POWER QUERY || TABLEAU || DATA ANALYTICS || TRAINING