Forum Discussion

danilomorganti's avatar
danilomorganti
Frequent Visitor
5 years ago

Relationship from two columns string (instring sql like)

Hello All! I need your help about relationship from two table.   In  this table I have a similar column called TEXT_KEY (it is a concatenate of string) and I would like to create a relationship fr...
Need Help
Tips and Tricks
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can do a fuzzy merge in the query editor, but not on the DAX side.  You could approximate it using FILTER and SEARCH, CONTAINS, LEFT, etc., if the two columns differ in a similar way.

 

Regards,

Pat