Create relationship based on matching first X number of characters

[sschwartzvcs]

I am trying to create a visual using two tables of customer data. Both tables contain the customer name - trouble is table 1 has the customer's full legal name and table 2 has an abbreviated name in some cases. 

Example:

Table 1: Acme Builders, Inc.

Table 2: Acme Builders

I'm trying to create a relationship between the two fields but getting a bunch of blank values when a record's name doesn't match the name in the other table exactly. Is it possible to have a powerbi relationship only match based on the first 10 characters? Or another way to solve this I'm not thinking of?

Thanks!

[dilumd · Accepted solution]

HI @sschwartzvcs

In the query editor, you can use extract function under transform menu to extract part of the text to a new column.

Try that and see.

[sschwartzvcs]

Thanks @dilumd - that should do the trick!