Forum Discussion

sschwartzvcs's avatar
sschwartzvcs
New Member
8 years ago
Solved

Create relationship based on matching first X number of characters

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!

  • 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.

2 Replies

  • dilumd's avatar
    dilumd
    Icon for Impactful Individual rankImpactful Individual

    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.