Hello Guys! I’m Ch. Lalitha Kalyan a data analytics enthusiast, as part of my learning in the field of data analytics I’m here to share my views on Power BI joins.
Introduction to joins:
Joins are basically used to combine different tables that can be either rows or columns. For ETL(Prepare, Clean, Transform and Load data) in Power BI, we usually have a huge amount of data, where we need to create joins between rows and columns of different tables in order to perform data analysis.
Different types of Joins available in Power BI:
Left outer join: all contents from the left table and only the matching contents from the right table are returned.
Right outer join: all the contents from the right table and only the matching content from the left table are returned.
Full outer join: merges both the tables from the left and right tables
Inner join: merges only the matching contents from the left and right table
Left anti join: it returns only the contents that are contained in the left table.
Right anti join: it returns only the contents that are contained in the right table.
7. Advanced example — case- insensitive text merge :
Power BI is case sensitive while performing merging on tables, therefore it is necessary to make sure that while merging both the matching contents should be of the same case/format.
After making them of the same case, we start performing merge/ join operations on the table.
8. Special Case — Cross Join :
It is a special case, where it forms a cartesian product from the two tables and there is no column that serves as a join condition. All rows of the left table are merged with all the rows of the right table.
תגובות