Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |