Forum Discussion
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 from table 1 to get data from table 2.
Is possibile to use Fuzzy function to create only relashionship?
Is there a way to create a SQL "like" relationship?
Many Thanks!
5 Replies
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
Thank you for your answer!
What I want is, when I click on the chart of table 1 if in table 2 there are some corresponding it populates a table view.Hi danilomorganti ,
Can you make some screenshots as examples to make the requirement more clear?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hello! You can find below a example of data
In a report I have a pareto with column WC and column VALUE from Table 1 and pareto with column CAUSES and column VALUE from tabel 1.
I would like when I click on pareto filter the table 2 based on column used in pareto.
If a I click on the first pareto, table 2 must to be filtered on colum WC, if I click on the second pareto, table 2 must be filtered on column CAUSES.
How can I do this type of automatic filter?
Many Thanks
Hi danilomorganti ,
Would you pls provide the sample data with pareto inside?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
