From the course: Power BI: Integrating AI

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Merging tables using fuzzy matching

Merging tables using fuzzy matching - Power BI Tutorial

From the course: Power BI: Integrating AI

Start my 1-month free trial Buy for my team

Merging tables using fuzzy matching

“

- [Instructor] When we merge two tables together in Power Query within Power BI, we have the option of choosing from one of six possible join types, like Left outer, Right outer, Full outer, Inner, Left anti, and Right anti joins. Join types aside, which could be a standalone course by itself, we can use fuzzy matching in our joins within Power Query to merge tables amongst a key column, even if the values within the field don't match exactly. In Power BI Desktop, we have two tables. One is a data table containing the value by energy source as a fact table. The other is a Dimension table containing the keys that we want to match to in the correct spelling. Let's go back to the Fact table, which contains misspelled energy source labels in the Category field. With this table selected, let's choose the option to merge this query with the other. When we merge tables together, we're combining them on a shared field or key that's present in both tables. We'll select the field containing the…

Contents